Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I sometimes rename a sheet it come back .xls]Newname? What's with
the ".xls]" portion? I didn't put that there. Thanks. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It might help us to figure out why if you showed us the code you are using
to rename the sheet. Rick wrote in message ... When I sometimes rename a sheet it come back .xls]Newname? What's with the ".xls]" portion? I didn't put that there. Thanks. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It's the last 4 characters of the workbook the sheet is in, and that usually
wouldn't appear unless you've linked cell via formula back to another workbook. -- Kevin Backmann " wrote: When I sometimes rename a sheet it come back .xls]Newname? What's with the ".xls]" portion? I didn't put that there. Thanks. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On May 30, 3:17*pm, Kevin B wrote:
It's the last 4 characters of the workbook the sheet is in, and that usually wouldn't appear unless you've linked cell via formula back to another workbook. -- Kevin Backmann " wrote: When I sometimes rename a sheet it come back .xls]Newname? What's with the ".xls]" portion? I didn't put that there. Thanks.- Hide quoted text - - Show quoted text - I got it. It showed up because I hadn't renamed the file yet. Once I did, I could change the names w/o .xls] showing up. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prefix .xls] after renaming a sheet? | Excel Discussion (Misc queries) | |||
Renaming Sheet Tab to Upper Case Letters | Excel Discussion (Misc queries) | |||
Get macro to run on any worksheet without renaming the sheet? | Excel Discussion (Misc queries) | |||
renaming sheet tabs in a sequence | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |