G
Guest
I have not been able to rename the worksheet
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nick Hodge
Gener
You cannot use certain reserved characters or the name History
?\*/][
It is limited to 31 characters and cannot be blank
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
You cannot use certain reserved characters or the name History
?\*/][
It is limited to 31 characters and cannot be blank
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
G
Guest
I am aware that certain characters are illegal. However, somehow a
worksheet got renamed ".XLS]JEENTRY". The problem is - how do I
get rid of the illegal character?
worksheet got renamed ".XLS]JEENTRY". The problem is - how do I
get rid of the illegal character?
Nick Hodge said:Gener
You cannot use certain reserved characters or the name History
?\*/][
It is limited to 31 characters and cannot be blank
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
gener said:I have not been able to rename the worksheet
G
Guest
Just a thought ..
Try saving the new file first before you rename the sheet(s).
Try saving the new file first before you rename the sheet(s).
G
Guest
The illegal character occurred when I renamed a worksheet, I didn't
intentionally add the illegal character. I want to know how to get rid of
the illegal character.
intentionally add the illegal character. I want to know how to get rid of
the illegal character.
Max said:Just a thought ..
Try saving the new file first before you rename the sheet(s).
---
gener said:I am aware that certain characters are illegal. However, somehow a
worksheet got renamed ".XLS]JEENTRY". The problem is - how do I
get rid of the illegal character?
G
Guest
Did you try opening a command line interface under the directory / folder in
which the file exists and renaming the file using the "ren" command? Which
version of Windows are you using? We need you to tell us HOW (what methods
you used) you tried to rename the file. I'm assuming you can't open it with
Excel. If you could you could just Save As and name it something else.
which the file exists and renaming the file using the "ren" command? Which
version of Windows are you using? We need you to tell us HOW (what methods
you used) you tried to rename the file. I'm assuming you can't open it with
Excel. If you could you could just Save As and name it something else.
gener said:The illegal character occurred when I renamed a worksheet, I didn't
intentionally add the illegal character. I want to know how to get rid of
the illegal character.
Max said:Just a thought ..
Try saving the new file first before you rename the sheet(s).
---
gener said:I am aware that certain characters are illegal. However, somehow a
worksheet got renamed ".XLS]JEENTRY". The problem is - how do I
get rid of the illegal character?
M
Max
I experienced recently the same phenomena as you did, in a new file which
was unsaved. Like you, I was unable to rename the sheet, not until I saved
the file. I don't know why it occurs, but that seemed to correct the
situation.
was unsaved. Like you, I was unable to rename the sheet, not until I saved
the file. I don't know why it occurs, but that seemed to correct the
situation.