squidmark
Board Regular
- Joined
- Aug 1, 2007
- Messages
- 105
Hi. this is my first post, and I searched the archives for this issue before posting, but couldn't find anything.
I came to work on my excel workbook today and tried to name a worksheet from 'Sheet 2' to '2 Aug'. When I finished, Excel automatically added a '.xls]' to the begging of the worksheet name.
When I tried to delete the .xls], excel kept giving me an error message stating:
"While renaming a sheet or chart, you entered an invalid name. Try one fo the following:
- Make sure the name you entered does not exceed 31 characters
- Make sure the dame does not contain any of the following characters: :/\* [ or ] (this puzzles me, because I actually REMOVED a "]" that Excel had put in there)
- make sure you did not leave the name blank.
Could I have checked or unchecked something in Tools>Options that makes it necessary for Excel to automatically prepend the worksheet with that ".xls]"?
Thanks
I came to work on my excel workbook today and tried to name a worksheet from 'Sheet 2' to '2 Aug'. When I finished, Excel automatically added a '.xls]' to the begging of the worksheet name.
When I tried to delete the .xls], excel kept giving me an error message stating:
"While renaming a sheet or chart, you entered an invalid name. Try one fo the following:
- Make sure the name you entered does not exceed 31 characters
- Make sure the dame does not contain any of the following characters: :/\* [ or ] (this puzzles me, because I actually REMOVED a "]" that Excel had put in there)
- make sure you did not leave the name blank.
Could I have checked or unchecked something in Tools>Options that makes it necessary for Excel to automatically prepend the worksheet with that ".xls]"?
Thanks