Alert Message - Sheet Naming

0

Hi,

I keep getting this Alert messge when trying to name a sheet saying I am using invalid characters when I am not. It won't let me save or move and no matter what I change the sheet name to the same message keeps appearing. 

Any advice would be amazing!

Thanks,

Sara

Answer
Discuss

Discussion

What are you trying to name the sheet? Also, what language are you using for Excel?
don (rep: 1482) Sep 20, '17 at 2:56 am
Expenses - what I am trying to name the sheet. And in English
Sara (rep: 2) Sep 20, '17 at 3:59 am
Add to Discussion

Answers

1
Selected Answer

You can't use the following characters in Excel tab names: / \ [ ] * ?

The list includes the colon which can be entered by some means but not by others and may be changed into a space by Excel.

In addition to these forbidden characters you must observe that a tab name can't be longer than 31 characters (presumably 15 for 2-byte Unicode characters), and you can't name a sheet "History" because Excel maintains a sheet by that name itself. (They don't let you see it, but it's there.)

I googled "can't rename excel tab" and found most people with that problem had downloaded the workbook from the Internet or received it by email. They complained about the loss of other normal Excel functionality. The consensus seems to be that the workbook is corrupt in some way. Nobody seems to have a resolution for the problem, but you may find hope or inspiration by looking for yourself.

You may try to copy the data from your workbook to a completely new one and hope that the error doesn't get copied along with the data.

Discuss

Discussion

Thank you, yes the sheet itself seemed to be corrupted for some reason. A friend simply pressed the esc key to get me out of the 'stuckness' and when I went to the next sheet it was fine. So I copied the content over and deleted sheet 1. Problem solved:)
Sara (rep: 2) Sep 20, '17 at 7:19 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login