Finding a #DIV/0! Error

[Chad C]

I have a program that feeds results into Excel. When
running this program, I receive a message that the
workbook that the results are fed into has a #DIV/0!
Error. The problem is that I can not find this error.
This workbook has several tabs and I can not see this
error anywhere. I have tried using the Find Tool, the Go
To Tool and have viewed each individual sheet in the
workbook, however no luck. Any suggestions on locating
this error. I have used a tool before to locate hidden
Links. Anyone know of a similar tool to search for hiddne
#DIV/0! Errors?

Thank you.

Chad C

 

[beeawwb]

What cells are using division formula's in your worksheet. I had a
similar problem not so long ago, whereby I was getting Div/0 errors. I
changed all my division formulas to IF(ISERROR)'s

Example.

=IF(ISERROR(G15/F15),"", G15/F15)

That way, if there's a divide by zero, the cell becomes a blank. Maybe
that'll help you find / solve your problem?

Hope it helps.

-Bob

 

[Ron de Bruin]

Try this Chad

Press F5
Click on Special
Select Formulas and only select errors

 

[Ron de Bruin]

Oops Sorry
You used(F5) already

 

[Norman Harker]

Hi Chad C!

Try using:

Edit > Goto > Special
Formulas
Uncheck all except Errors
OK

If the error is on the sheet the first case will not be shaded.
If the error is not on the sheet the unshaded cell will direct you to
where it got the error from.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.