ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tab Name Change Error .xls] inserted (https://www.excelbanter.com/excel-discussion-misc-queries/30545-tab-name-change-error-xls%5D-inserted.html)

Alayna

Tab Name Change Error .xls] inserted
 
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.

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.)

Alayna wrote:

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.


--

Dave Peterson


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com