TROUBLE RENAMING A WORKSHEET IN EXCEL 2000

[Guest]

I am getting the message that i've either entered a wrong symbol, used too
many letters..., but i did not and now it won't take any name. On the other
worksheet the extension xls appeared on the tab. And I can't close anything
or save my Excel file. HELP!!!

 

[Don Guillett]

Perhaps you mean workBOOK instead of worksheet??
what did you try to name it?

 

[Peo Sjoblom]

I would copy all info over to a new workbook, I think I saw something
similar and it was impossible to rename the sheet

so copy over all correctly named sheets to another workbook by right
clicking the tab and selecting move or copy and for the corrupt sheet if you
have any formulas do edit replace = with ^^=, select the whole sheet and
copy it, then paste it into a new sheet in the new workbook, when copied
over reverse the replace and replace ^^= with =, then rename the sheet.
Don't use illegal characters this time

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey