can't change sheet name on tab

L

LisaAnn

have used excel forever and have not encountered this problem. have tried to
rename a tab at the bottom of the sheet and keep getting error message saying
i've used an invalid name/character. i haven't used anything that is
disallowed... just the word "Staff" or "Department" no other symbols or
numbers, etc. i checked sheet protection... okay. it also will not close the
program without fixing this problem.
 
L

LisaAnn

i think i have the problem solved... although i would like to know why? i
found that the person named the whole spreadsheet with [ brackets ] as a part
of the name. as soon as i took those out, the tabs could be renamed. if
anyone can share how that worked i'd like to know! Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top