ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Naming Worksheets (https://www.excelbanter.com/excel-worksheet-functions/41487-naming-worksheets.html)

LIAMT

Naming Worksheets
 
I've added some worksheets to an excel file. The problem is that when I
rename any of the sheets the following appears before the characters in the
name: .xls] e.g. if I call the sheet TEST, it immediately adjusts to
..xls]TEST.

What is this ? and is there so way I can turn it off?
--
LT

Dave Peterson

Make sure that the file name doesn't contain any of those square brackets.

Close the file and use windows explorer to rename it.



LIAMT wrote:

I've added some worksheets to an excel file. The problem is that when I
rename any of the sheets the following appears before the characters in the
name: .xls] e.g. if I call the sheet TEST, it immediately adjusts to
.xls]TEST.

What is this ? and is there so way I can turn it off?
--
LT


--

Dave Peterson


All times are GMT +1. The time now is 05:50 AM.

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