When Closing Workbook Get this Error Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

"Your formula contains an invalid external reference to a worksheet

Verify that the path, workbook, and range name or cell reference are correct, and try again."

How can I find out in an efficient way that what reference is invalid. Thanks all experts.
 
Thank you Frank. I unzipped the add in, but I don't know how to use it. Would you please give me a pointer on how to use it? I will search the google at the same time. Thanks again.
 
Hi
- goto 'Tools - add-in Manager'
- search for this Add-in and install it
- You should now have a menu entry 'Find Links' within the 'Tools' menu
 
You must log in or register to reply here.

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

Trace errant formula to stop annoying message 13
How to reference a cell from anther workbook without opening it 0
Strange problem when running macro from PPT'07 copying ranges from 2
2007 Update 3
Invalid external reference message 2
Finding one or more "Invalid References" in big spreadsheet 1
How to find invalid formula references with VBA 2
Copying cells and formula from closed workbook to all sheets in open workbook 0

Back
Top