how to fix REF and VALUE with a circ ref with iteration

S

shant.sood07

I have a complicated model that has a circ ref built on purpose, so the iteration is turned on (100x, .001 max correction). However, if there's a cellthat I'm working on that shows a REF or VALUE (basically if I delete something by mistake), even if I go back and fix what causes the REF or VALUE, it ripples across the spreadsheet and I can't seem to reverse it. I've had to go to previous version of the spreadsheet and start over - what a pain!

Would appreciate any thoughts. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with SET & REF function 0
how to remove #REF and #N/A 4
How to replace #REF! with 0 2
#value / #ref for the cells with link to other Excel files 0
Calculate sum of values based on a ref value, how? 4
Database to Excel REF#! 1
Word macro that can call cells out of Excel for a find and replace 0
How to prevent a formula from returning #REF! instead return 0 2

Top