Finding errors in formulaes

  • Thread starter Thread starter norcombe
  • Start date Start date
N

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
 
If you are looking for explicit errors like #REF!, #N/A etc?

press F5, select special, select formulas and uncheck everything but errors
 
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
 
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
 
Back
Top