Circular Reference with =NOW() entry

markstro

Board Regular
Joined
Sep 8, 2008
Messages
106
Why does Excel 2007 return a circular reference when I have =NOW() entered in a cell when it did not appear in 2003??
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
I'm guessing there's something else going on in the cell containing NOW().
XL2007 doesn't flag just that function as causing a circular reference.
 
Upvote 0
I never had a problem with 2003, converted to 2007 and these references started popping up only on those cells that had the =NOW() in them. I can live with it, just want to make it go away if I can.
 
Upvote 0
Here's what I just tried:

•Opened XL2003
•Entered =NOW() in cell A1
•Saved and closed the file (Book1.xls)
•Closed XL2003

•Opened XL2007
•Opened Book1.xls....no circular ref
•Saved the file as an XL2007 file (Book1.xlsx)...still no circular ref
•Closed Book1.xlsx

If you delete all of the other cells in the sheet and leave the NOW() cell
...do you still get the circular ref?
If yes....and you delete the NOW() cell....circular ref?
 
Upvote 0
I had circular references in other cells but the =NOW() cells were identified first as having the reference, once I deleted the =NOW() cells the other cells were identifed, fixed those so I can now enter the function without the circular reference.
 
Upvote 0

Forum statistics

Threads
1,215,001
Messages
6,122,648
Members
449,092
Latest member
peppernaut

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top