Excel keeps telling me one or more circular references error
I have a workbook that keeps telling me that there one or more circular references where a formula refers to own cell.
Ive done the error checking on the formula tab and it says that they are all complete and dont come up with any but everytime I open the book it says the message above.
Any ideas?
Book enclosed
NEWCUBICANDSHERESHEET sunday.xlsm
Ive done the error checking on the formula tab and it says that they are all complete and dont come up with any but everytime I open the book it says the message above.
Any ideas?
Book enclosed
NEWCUBICANDSHERESHEET sunday.xlsm
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You’re welcome and I’m glad I was able to help.
If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Distinguished Expert in Excel 2018
Experts Exchange Top Expert Visual Basic Classic 2012 to 2020
Experts Exchange Top Expert VBA 2018 to 2020
If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Distinguished Expert in Excel 2018
Experts Exchange Top Expert Visual Basic Classic 2012 to 2020
Experts Exchange Top Expert VBA 2018 to 2020
I always recommend to use Auditing tools in Excel to these issues.
"Shift Sheet" cell P29 refers to itself.
Finding Circular Reference is relatively simple, bottom left of the Status Bar tells you there is Circular Reference; if it is on the active sheet it gives the cell reference.
Finding Circular Reference is relatively simple, bottom left of the Status Bar tells you there is Circular Reference; if it is on the active sheet it gives the cell reference.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER