Solved

MS Excel worksheet renaming problem

Posted on 2003-11-11
3
1,760 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
Calculating Sales Tax 13 61
Excel VBA inserting a formula 12 32
Paste Table from Excel VBA to the PowerPoint 2010 18 45
Excel - Active X Checkboxes Groups 45 30
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

740 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