|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I keep getting messages that there is "one or more circular references" in nearly every spreadsheet
This started a few days ago. In nearly EVERY spreadsheet I open that does not contain formulas I get the following message: "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try moving or changing these references, or moving the formulas to different cells." This happens in spreadsheets I have opened recently and have had no problems with up until a few days ago. I have no idea what's causing the problem, or how to make it go away. I have completely shut down my computer and restarted everything (I know that's usually the first suggestion). Interestingly, spreadsheets that actually do contain formulas, have not shown this error message. The spreadsheets with the problems are all text -- weekly menus, new spreadsheet for workflow over the next few days. Stuff like that.
Help! Thanks!! |
#2
|
||||
|
||||
Please post a sample sheet showing the error. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
If the sheets contain only text have you tried selecting all cells then formatting them as "Text" or "General".
Also, if it started "a few days ago" then maybe an Office update has caused it? |
#4
|
|||
|
|||
Quote:
You might try ALT + O H U (hold down ALT and tap O, H, U in succession - shortcuts for fOrmat/sHeet/Unhide) to unhide any hidden sheets. Also check for hidden rows and/or columns where formulas could be hiding. If it's supposed to be all text, you can try using Find for an equals sign ("="), which should take you to any formulas that might be off the visible part of the page. And try CONTROL + A keys to select all cells, then copy and paste values, which should eliminate any formulas within cells. |
Tags |
circular reference, error messages |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro | Matt C | Excel Programming | 2 | 01-08-2022 06:03 AM |
Excel says non-circular references are circular. | coffent | Excel | 5 | 04-18-2021 11:07 PM |
"Circular References," but formatted as text | newmaven | Excel | 3 | 12-13-2016 02:23 PM |
Updating "Parent Phrase" to change all Child Phrases - (References, Fields, Headings?) | tclass117 | Word | 1 | 11-18-2016 10:14 PM |
Spreadsheet with "CR" & "DB" in amount & number columns. | bfisher | Excel | 4 | 09-28-2015 07:03 AM |