Solved

MS Excel worksheet renaming problem

Posted on 2003-11-11
3
1,759 Views
Last Modified: 2012-06-21
I am using windows 98 and MS Excel 97.  I have a workbook having 2 sheets namely "31.08.03" and 30.09.03", in which if I rename a perticular sheet-name and press enter, it prefix ".xls]" to the sheet-name. for example, if I rename the sheet "31.08.03" as "ABC" and press enter, it rename the sheet as ".xls]ABC".  Now, if I try to rename the sheet ".xls]ABC" as "31.08.03" again it shows the error message as "while renaming a sheet or chart, you entered an invalid name.Try one of the following."  Please note that i am not using any special-characters in the sheet name. i have used quote marks to only highlight the sheet names. This problem is not appearing in any newly created workbooks.
0
Comment
Question by:tppramod
3 Comments
 

Accepted Solution

by:
Geeezah earned 25 total points
ID: 9809758
Rename the Workbook removing any "[" or "]"
Worked for me
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question