Finding errors in formulaes

[norcombe]

Hi,

I am reviewing financial models that use constant formulae across rows.
Is there an easy way of finding inconsistencies in rows (e.g where the
formula has been changed).

At the moment I switch the Tools>Options>View to formulas and manually
trawl through, but when the spreadsheet runs to +2000 rows and +500
columns this is impossible.

Thanks

 

[Peo Sjoblom]

If you are looking for explicit errors like #REF!, #N/A etc?

press F5, select special, select formulas and uncheck everything but errors

 

[Tina]

You could try tools auditing trace dependants or precedents these show lines to where formula from

----- norcombe > wrote: ----

Hi

I am reviewing financial models that use constant formulae across rows
Is there an easy way of finding inconsistencies in rows (e.g where th
formula has been changed)

At the moment I switch the Tools>Options>View to formulas and manuall
trawl through, but when the spreadsheet runs to +2000 rows and +50
columns this is impossible

Thank

 

[Dana DeLouis]

In Excel XP, there is an option to find "Inconsistencies" in formulas. It
is under "Tools", "Options", "Error checking Tab" and select the option
"Inconsistent formula in region."

HTH.

Dana DeLouis
Using Windows XP & Office XP