![]() |
#4
|
|||
|
|||
![]()
Thanks for your help, xor and Pecoflyer.
Bottom line first: I think I've discovered a new way to fix problems in Excel: simply *ask* for help and the problem goes away! More discussion: I'd been living with or trying to fix this problem for a couple of weeks. Xor, Excel claimed I had any number of circular references. For example, if I deleted the contents of cell M8 in my example, then Excel would say I had a circular reference somewhere else, and if I deleted the contents of that cell (which was *not* a circular reference) it would claim there was a circular reference in yet a third place, and so on. My Excel file had several sheets, so I tried copying and pasting the contents of the sheet where all the problems were alleged to have occurred into a new Excel spreadsheet, but again got the circular reference problem. However this morning (after rebooting) when I opened the spreadsheet in response to your suggestions, the problem was gone! I have no idea what changed. I'd made a number of changes searching for the root of the problem, but - I think! - reversed them all. So again, thanks for the help. Pecoflyer, using INDEX might be a better approach than INDIRECT - I'll look into it. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Circular Reference - Getting Around It | Pluviophile | Excel | 3 | 09-19-2020 01:19 PM |
circular reference | riothecat | Excel | 6 | 06-29-2017 10:56 AM |
"Circular References," but formatted as text | newmaven | Excel | 3 | 12-13-2016 02:23 PM |
![]() |
Rahmat_uk20 | Excel | 3 | 06-08-2012 02:31 AM |
Circular error | markg2 | Excel | 2 | 05-17-2010 07:39 AM |