Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mysterious Circular Reference
I created a rather large P&L projection model (11+ Mb, 68 sheets). When
modifying the 2007 sheets using "methodology" used in 2006 sheet, a Circular Reference error appeared. Note: the methodology I developed for 2006 worked fine and did not generate a circular reference message. Only when I was creating/copying the new sheets/formulas into the 2007 area did the problem occur. Several hours later, I need some help... Information which may help you help me/actions taken to ID root of problem: - no cell location appears next to the Circular Reference msg in the lower toolbar, on any of the sheets/tabs in the spreadsheet - the Circular Reference toolbar has 1 address shown in the drop down list, but it cannot be "selected" - I have systematically deleted sheets out of the wb (from 68 down to 1) and the message hasn't disappeared - I have "valued" every single sheet in the wb, effectively eliminating all formulas, yet the Circular message is still displayed - I have experimented with the Iteration & Maximum Change settings in Tools/Options/Calculation, to no avail. 20 plus years using spreadsheets, and I'm totally lost how to find/fix this problem... Any suggestions? Any possibility that the message is erroneous, that a "flag" has been set that needs to be reset (I'm reaching now...) Please help -- Randy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference toolbar not working | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Discussion (Misc queries) | |||
goal seek circular reference | Excel Discussion (Misc queries) | |||
Circular Reference... Help! | Excel Worksheet Functions | |||
Help solve a Circular Reference | Excel Worksheet Functions |