Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Alayna
 
Posts: n/a
Default 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.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change cell shading whenever contents different from previous cell zooeyhallne Excel Discussion (Misc queries) 3 June 6th 05 09:59 PM
conditional cell shading when a change occurs zooeyhall Excel Discussion (Misc queries) 1 June 6th 05 05:14 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 06:37 PM
how do i make a date change automatically if i change one before . dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:21 PM
How do I change how a file is inserted into outlook? km6090 Excel Discussion (Misc queries) 1 December 12th 04 10:17 PM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"