LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
George
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Iterate Circular Reference Brandt Excel Discussion (Misc queries) 1 August 3rd 05 11:43 PM
Highest Value / Circular Reference Help Josh M Excel Discussion (Misc queries) 1 May 23rd 05 07:33 PM
Highest Value / Circular Reference Help Josh M Excel Worksheet Functions 0 May 23rd 05 06:49 PM
Help solve a Circular Reference brupub Excel Worksheet Functions 6 February 14th 05 07:11 AM
Circular reference Pat Excel Discussion (Misc queries) 2 January 19th 05 05:52 AM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"