Hi,
I have a huge excel financial model that has not been properly updated and hence I get Div/0 errors frequently. Is there any way to track the "original source/calculation which causes the Div/0 error"? I've been using precedents/antecedents to identify most but this one is particularly difficult to track down.
As far as macro solutions, I only know of a way to replace the Div/0 errors with 0's or replace them with the iserror function which is not useful since not all Div/O errors are "0's" but "actual values."
This is somewhat urgent and I really appreciate any help/assistance, Thanks very much!
I have a huge excel financial model that has not been properly updated and hence I get Div/0 errors frequently. Is there any way to track the "original source/calculation which causes the Div/0 error"? I've been using precedents/antecedents to identify most but this one is particularly difficult to track down.
As far as macro solutions, I only know of a way to replace the Div/0 errors with 0's or replace them with the iserror function which is not useful since not all Div/O errors are "0's" but "actual values."
This is somewhat urgent and I really appreciate any help/assistance, Thanks very much!
