• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Formula help Needed

S

saadferoze

New Member
Dear Members,


I have prepared the model and its working perfectly fine as per the technicalities . The only issue which i am facing right now is whicle testing the formulas and model, if i remove one cell or delete which is linked to the other formulas just to check what happens then it shows REF!!!. which makes the output cells of the model also REF!!! How ever if i undo it and the cell which is linked to other output cells comes back to its original value or number still the out put cells show REF!!!. how to solve this issue


Thanks and Regards

Saad
 
You will need to re-establish the formula/s that connected to the cell you deleted

As they now don't know where to look


Use the Auditing tools (Formula Ribbon) and follow the errors
 
You must log in or register to reply here.
Back
Top