I renamed a sheet and am getting the error, "While renaming a sheet or chart, you entered an invalid name, Try one of the following" blah blah blah. The sheet name is valid, does not have any characters and isn’t too long.
What’s the problem? Well, I searched internet and found this might solve the problem.
The following information is from: http://www.mrexcel.com/forum/showthread.php?t=157564
This topic may be dead, but i think i know what causes this phenomenon. And this might be helpful for someone else who might be searching the forum.
This happens to me every time I try to rename a sheet in an excel file that is in a "temp" directory. There are usually illegal characters in the file name, IE. "Sales Analysis -[1]". If I choose rename and name my sheet "Book1" Excel names the sheet ".xls]Book1", then you get the error.
At that point the only thing you can do is to "X" out of the workbook and select save changes. Then select file —>open and click My recent documents to open the workbook. Then click file save as, and save the file to a normal directory with a valid file name. Now you can change the invalid sheet name.
Recent Comments