Rename Excel Worksheet Causes Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to rename my sheet and it popped up a .xls in front of the name for
the tab. I deleted the .xls (Mind you this is just the name on the tab for
one sheet in
a series). It now won't accept anyname and keeps telling me to I should use
blanks or certain characters. I have tried single letters, single numbers.
Nothing works and it will not let me out of the sheet.
 
I have had this problem also. It occurs infrequently and I have not yet
found any pattern to its occurrence. This is a highly annoying bug, I hope
someone addresses it.

For what it's worth, I found that I can break out the the 'invalid name'
loop by hitting Escape. It allows me to continue using the file without
losing my edits, but it also leaves the objectionable worksheet name intact.
I find that I can then rename the worksheet at a later time.
 
Check this thread:

"Prefix .xls] after renaming a sheet?" in Excel General Questions

The problem may be bracket characters in the filename.
 
I found a fix. It happens when I open a spreadsheet that has been emailed to
me. If I save the spreadsheet to my harddrive, before I play with it, then I
have no problem with the Tab name change.

Thanks for the response!

Bill

Leecu said:
Check this thread:

"Prefix .xls] after renaming a sheet?" in Excel General Questions

The problem may be bracket characters in the filename.
--
Leecu


Leecu said:
I have had this problem also. It occurs infrequently and I have not yet
found any pattern to its occurrence. This is a highly annoying bug, I hope
someone addresses it.

For what it's worth, I found that I can break out the the 'invalid name'
loop by hitting Escape. It allows me to continue using the file without
losing my edits, but it also leaves the objectionable worksheet name intact.
I find that I can then rename the worksheet at a later time.
Click to expand...
Click to expand...
 
Back
Top