Forum Discussion
Today Function circular reference
Follow the conclusion in the discussion at https://www.mrexcel.com/board/threads/circular-reference-with-now-entry.444298 , to wit:
``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.``
-----
LeeL365 wrote: ``When I do error checking, I get the sheet is clear of errors. ``
In my version of Excel, "error checking" is different from checking for "circular references".
But Excel might not identify the truly offending circ refs unless and until you delete the cell(s) that reference TODAY (and other "volatile" functions), just for troubleshooting purposes.
-----
LeeL365 wrote: ``I have other errors, in other worksheets in the book, but I have set them all to be ignored.``
"Errors" that you can ignore are actually warnings, despite MSFT's misrepresentation.
I presume you are talking about the warnings identified by a triangle in the upper corner of a cell.
Those are differences among surrounding cells. Often, we choose those differences on purposes.
If you want to avoid those distracting warnings, (in my version of Excel) click File > Options > Formulas, deselect (uncheckmark) "Enable background error checking", and click Reset Ignored Errors.
JoeUser2004 Thank you. I have done all of that. to no avail. The error checking says no circular references, however, I get a warning display each time I open the sheets and also in the lower left where the error seems never to go away. I will try just recreating the sheet and going from formula to formula. This sheet was created under an older version of excel and I thought it had been updated, but I was wrong.
Thanks anyway
LeeL365 JoeUser2004
Same problem here, and just started recently (Ibelieve after the last update) in all workbooks I open. Even starting from scratch with a brand new workbook, a simple =TODAY() in A1 causes a circular reference. Likely an update bug?lukebutler wrote: ``Even starting from scratch with a brand new workbook, a simple =TODAY() in A1 causes a circular reference. Likely an update bug?``
Follow these instructions to execute Excel in safe mode. (I don't know if these instructions work with Office 365 Excel.)
1. Close all windows.
2. Press and hold the Ctrl key until step #5.
3. While pressing the Ctrl key, click on the Excel program icon, not a file icon.
4. While pressing the Ctrl key, wait for the following pop-up.
5. Release the Ctrl key, and click Yes.
6. In Excel, confirm that the application title says "Safe Mode".
7. Enter the formula =TODAY() into A1.
Do you get a circular reference error?
If not, repeat the procedure without executing Excel in safe mode.
1. Close all windows.
2. Click on the Excel program icon, not a file icon.
3. In Excel, confirm that application title does not say "Safe Mode".
4. Enter the formula =TODAY() into A1.
Do you get a circular reference error?
