Tab Name Change Error .xls] inserted

G

Guest

I have done something to my workbook and don't know how I did it. Everytime I
add a new worksheet or rename an existing worksheet, Excel automatically puts
".xls]" in front of the name on the tab. When I attempt to delete .xls] it
says that I have now entered an invalid name.

Can anyone tell me what I did and how to fix it? Thank you for your help.
 
D

Dave Peterson

Close that workbook and go to windows explorer.

Traverse to the folder that holds the file. Rename that file so that it doesn't
include any [ or ] characters.

(Those characters confuse excel.)
I have done something to my workbook and don't know how I did it. Everytime I
add a new worksheet or rename an existing worksheet, Excel automatically puts
".xls]" in front of the name on the tab. When I attempt to delete .xls] it
says that I have now entered an invalid name.

Can anyone tell me what I did and how to fix it? Thank you for your help.
 

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