Home |
Search |
Today's Posts |
#1
|
|||
|
|||
clear circular reference fault?
I have a worksheet with a number of circular references. I have
iteration turned on, and it seems to do what I want. But, if I make some particular mistakes (eg: entering really unreasonable data), I get into a situation where most of the cells are #VALUE. The only way I've found to clear this is to re-load a good copy of the sheet. 'Undo' has no effect. Are there better ways to recover from this? More generally: my knowledge of Excel is kind of spotty. I don't have the time to become expert in Excel, but sometimes I want to use some particular more advanced feature. The built-in help seems kind of limited, unless I missed something in the installation. So, I flounder around. Is there an on-line "Excel reference manual", or something? Thanks, George |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Iterate Circular Reference | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
Help solve a Circular Reference | Excel Worksheet Functions | |||
Circular reference | Excel Discussion (Misc queries) |