Circular Reference grayed out

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Circular Reference grayed out

  1. #1
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    630
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Circular Reference grayed out

     
    My user has a large workbook with circular reference errors on every single tab. I have tried to chase down the errors but have had no success; in fact, I can't seem to find any circular references that exist. However, when I go to FORMULAS, FORMULA AUDITING, ERROR CHECKING the Circular Reference option is grayed out on every sheet.

    Can someone tell me why it is grayed out and how to get rid of the errors without it?
    Thanks,
    Shirlene

  2. #2
    Board Regular
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,373
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Circular Reference grayed out

    Any hidden sheets?
    Neil

  3. #3
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    630
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Circular Reference grayed out

      
    No hidden sheets or columns or rows

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com