Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2022, 12:19 PM
MaryannaC MaryannaC is offline I keep getting messages that there is "one or more circular references" in nearly every spreadsheet Windows 10 I keep getting messages that there is "one or more circular references" in nearly every spreadsheet Office 2019
Novice
I keep getting messages that there is "one or more circular references" in nearly every spreadsheet
 
Join Date: Feb 2022
Posts: 1
MaryannaC is on a distinguished road
Question 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!!
Reply With Quote
  #2  
Old 02-18-2022, 12:51 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline I keep getting messages that there is "one or more circular references" in nearly every spreadsheet Windows 7 64bit I keep getting messages that there is "one or more circular references" in nearly every spreadsheet Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 02-18-2022, 08:34 AM
wiganken wiganken is offline I keep getting messages that there is "one or more circular references" in nearly every spreadsheet Windows 11 I keep getting messages that there is "one or more circular references" in nearly every spreadsheet Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

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?
Reply With Quote
  #4  
Old 02-21-2022, 02:39 PM
kilroyscarnival kilroyscarnival is offline I keep getting messages that there is "one or more circular references" in nearly every spreadsheet Windows 10 I keep getting messages that there is "one or more circular references" in nearly every spreadsheet Office 2019
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by MaryannaC View Post
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!!
If you go to the Formulas ribbon and look for Error Checking (about 3/4 of the way to the right on mine), click on the dropdown and select Circular References, that should point you to the circular formula on the sheet.

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.
Reply With Quote
Reply

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
I keep getting messages that there is "one or more circular references" in nearly every spreadsheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft