How can I find an invalid reference?

[bugman]

I have a spreadsheet that used to have a chart in it. I removed the
chart and the entire column that it resided in. My spreadsheet is just
a report. It has no calculations it it. Yet every time I resize a
column I get a "a formula in this worksheet contains one or more invalid
references" message. How do I find the offending formula if none
exists?
thanks

 

[davegb]

Try doing an "Edit, Goto, Speical, Formulas, Ok" and see what cell it
highlights.

 

[Dave Peterson]

Search for "#ref" (without the quotes).

And Bill Manville's FindLink program will find them, too:
http://www.oaltd.co.uk/MVP/Default.htm

This will find them in places that edit|find won't look.