Results 1 to 3 of 3

Circular Reference grayed out

This is a discussion on Circular Reference grayed out within the Excel Questions forums, part of the Question Forums category; My user has a large workbook with circular reference errors on every single tab. I have tried to chase down ...

  1. #1
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    572

    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
    6,447

    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
    572

    Default Re: Circular Reference grayed out

    No hidden sheets or columns or rows

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