Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Tags
circular reference, error messages



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 03:40 PM.


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