+ Reply to Thread
Results 1 to 3 of 3

While renaming a sheet... bug?

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    Turkey
    MS-Off Ver
    Mac 2011
    Posts
    3

    Cool While renaming a sheet... bug?

    Folks, this is driving me nuts. I'm an experienced Excel user and whilst I can find many threads relating to the above I can't find one that solves my issue. I am however new to Mac Excel 2011 (although I don't think that's an issue).

    Occasionally when I try to rename a sheet or reference a cell in a formula Excel has a hernia (see attachment). With the referencing to another sheet within the current workbook it thinks I'm looking for an external file (!{sheetname} it interprets as an external link).

    At each occurrence I only have 1 workbook open and there are no hidden ones.

    Can you resolve this one for me?

    Thanks
    Mark
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: While renaming a sheet... bug?

    The error message shows you are using one of invalid characters in naming a sheet. You can not use chr like /\ when you name a sheet.

  3. #3
    Registered User
    Join Date
    05-24-2013
    Location
    Turkey
    MS-Off Ver
    Mac 2011
    Posts
    3

    Re: While renaming a sheet... bug?

    Thanks for the offer, but read experienced Excel user/read forums etc

    I discovered it's due to sharing of documents.

    Once the sharing is removed it works normally.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1