ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   When renaming a worksheet it puts ".xls]" in front of the name. (https://www.excelbanter.com/excel-discussion-misc-queries/22340-when-renaming-worksheet-puts-%22-xls%5D%22-front-name.html)

InexperiencedExcelUser

When renaming a worksheet it puts ".xls]" in front of the name.
 
When I go to rename a worksheet it puts ".xls]' in fron to the name. When I
delete this it still comes up with an error and won't let me proceed.
Is this a bug? If so, does anyone know how to rectify?

JE McGimpsey

Rename your file without bracket characters ([ or ]). See:

http://support.microsoft.com/kb/q215205/

In article ,
"InexperiencedExcelUser"
m wrote:

When I go to rename a worksheet it puts ".xls]' in fron to the name. When I
delete this it still comes up with an error and won't let me proceed.
Is this a bug? If so, does anyone know how to rectify?


InexperiencedExcelUser

Dear JE McGlimpsey

THANK YOU SO MUCH - the file name did not have [ in it, however, when I
renamed it it worked !!

"JE McGimpsey" wrote:

Rename your file without bracket characters ([ or ]). See:

http://support.microsoft.com/kb/q215205/

In article ,
"InexperiencedExcelUser"
m wrote:

When I go to rename a worksheet it puts ".xls]' in fron to the name. When I
delete this it still comes up with an error and won't let me proceed.
Is this a bug? If so, does anyone know how to rectify?




All times are GMT +1. The time now is 09:36 PM.

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