How to get rid of "A formula in this worksheet contains one or moreinvalid references"

C

coffent

Frequently I'll delete some cells in an Excel 2007 worksheet and from
then on get the message "A formula in this worksheet contains one or
more invalid references." whenever I try to do anything in the
worksheet. There are no invalid references, as I have verified.
Possibly there were some temporarily while Excel was in the process of
deleting the cells. If I save the file, exit Excel, then reopen the
workbook, Excel changes its mind and decides there aren't any invalid
references after all (at least the message goes away). Is there any
way to get Excel to figure this out with shutting it down?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

invalid reference error saving 2003 file in 2007 0
Invalid references in a formulas 3
Finding one or more "Invalid References" in big spreadsheet 1
Formula with Invalid References Error Message 5
invalid references in formula 2
Invalid References in formula 3
Copying data and formulas from one workbook to another 0
How to find invalid formula references with VBA 2

Top