For a better experience, please enable JavaScript in your browser before proceeding.

Error Checking does not identify it; status bar indicates Circular Reference on each sheet but doesnt i.d.

The Sub also identified 4 other references: all formulas with the cell NOW().

Does that make sense Could another cell be using the NOW() cell in some way that creates the circle.

In my WB, other cells are not referring to the NOW function; nor am I combining the NOW() with any other terms or references in the offending cells.

It lists all cells in all sheets with formula containing Now() and any dependents in the same sheet.

Although I couldnt see the circular dependency, I disabled the dependent cells but still got the circular message on opening the WB.

It wasnt until I had disabled all NOW(()s that the message disappeared on opening the WB.

Then I entered a simple NOW() without any custom formatting and the WB behaves properly.

Do you think customizing the NOW() cells would create a problem It certainly shouldnt.

I really appreciate all the time you have put into this thread.

Am restoring NOW related cells one at a time, opening and closing each time.

In cell A2 if the value A then allow both positive and negative integers.

Search For Circular Reference In Excel Mac