Share via

Invalid name for sheet

Anonymous
2017-09-25T14:45:31+00:00

Hello,

I've been working on Excel 2011 for Mac for a long while.

Lately, I've been having issues with a file containing multiple sheets (10-15 or so).

I sometimes copy a sheet, by right click, "Move or Copy", and then I rename it similarly to the other sheet but put V2 or V3 etc.

I get the message "While renaming a sheet or chart, you entered an invalid name". This is a glitch because I when X close Excel and reopen and redo the same copy sheet and rename I don't have the error that pops up. It happens a lot as I'm working on this file.

I'm wondering is there something I can do to fix this glitch. Is there a way to check this excel file or something?

Thank you

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Jim G 134K Reputation points MVP Volunteer Moderator
2017-10-05T15:01:04+00:00

Anything other than a letter, number or space is considered to be a special character.

Was this answer helpful?

3 people found this answer helpful.
0 comments

Answer accepted by question author

Anonymous
2017-09-28T19:34:41+00:00

Hi Alexandre,

Is the issue fixed after you update the Office?

If the issue remains, you also can check Jim's reply to see if the issue is caused by the file path or any special character.

Thanks,

Rena

Was this answer helpful?

3 people found this answer helpful.
0 comments

12 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2017-10-07T19:20:19+00:00

    I think it ought to be enough, but if you want to be sure, use File > Save As to rename the file. That way any internal references will be changed when you save the file.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-10-06T15:58:24+00:00

    Hello Jim,

    Thanks for the info.

    So if I just changed the names of the files and sheets directly on the file, it should be enough or should I use another method?

    Thanks,

    Alexandre

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2017-09-25T15:03:04+00:00

    This is how I make a duplicate of a worksheet:

    Click the tab of the sheet in question; hold CTRL (not sure what that is on a Mac); drage the tab to where you want the copy.

    A sheet called Sheet1 generates a new sheet called Sheet1 (2); so sheet Friday makes sheet Friday (2)

    I then rename the new sheet as needed

    best wishes

    Was this answer helpful?

    0 comments