How do I get rid .xls] in front of the tab name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leatha - 05 Jul 2006 15:38 GMT

I renamed a worksheet and it put .xls] in front of the new name. When I try
to delete the .xls], it gives me an error message and won't allow me to save
the new name. I'm trying to rename the tab from APRIL '06 to JUNE '06.

Reply to this Message

Nick Hodge - 05 Jul 2006 18:32 GMT

Leatha

It sound like the workbook has some code to stop the worksheets being
renamed...I'd check it out with the owner of the workbook

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

>I renamed a worksheet and it put .xls] in front of the new name. When I try
> to delete the .xls], it gives me an error message and won't allow me to
> save
> the new name. I'm trying to rename the tab from APRIL '06 to JUNE '06.

Reply to this Message

Leecu - 23 Aug 2006 21:20 GMT

I don't think this is a question of access to the worksheet. I have had this
same condition occur on Excel files I created myself.

I think there is some kind of bad data that Excel writes into the filename
along with the '.xls]' which the user did not put there. The user is not
able to delete this bad data, whatever it is, so Excel keeps complaining
about invalid characters no matter what the user tries to change the name to.

I have had some luck breaking out of this situation by hitting Esc key.

Signature

Leecu

> Leatha
>
[quoted text clipped - 5 lines]
> > save
> > the new name. I'm trying to rename the tab from APRIL '06 to JUNE '06.

Reply to this Message

Leecu - 23 Aug 2006 21:29 GMT

Check this thread:

"Prefix .xls] after renaming a sheet?" in Excel General Questions

The problem may be bracket characters in the filename.

Signature

Leecu

> I don't think this is a question of access to the worksheet. I have had this
> same condition occur on Excel files I created myself.
[quoted text clipped - 15 lines]
> > > save
> > > the new name. I'm trying to rename the tab from APRIL '06 to JUNE '06.

Reply to this Message