problem with: hidden (invalid) external reference

  • Thread starter Peter van de Kerkhof
  • Start date
P

Peter van de Kerkhof

Hello,

I have a strange invalid external reference in a workbook

Sometimes when I close the workbook I get the following message:
Your formula contains an invalid external reference to a worksheet
....
(No error at opening of the workbook).

The problem is that:
- I don't know wich of the 15 worksheets causes the problem
- I can't repeat the problem
- the Edit; Links menu option shows nothing (not highlighted)

can anybody help me

Regards Peter
 
H

Hank Scorpio

Hello,

I have a strange invalid external reference in a workbook

Sometimes when I close the workbook I get the following message:
Your formula contains an invalid external reference to a worksheet
....
(No error at opening of the workbook).

The problem is that:
- I don't know wich of the 15 worksheets causes the problem
- I can't repeat the problem
- the Edit; Links menu option shows nothing (not highlighted)

can anybody help me
Click to expand...

I suggest that you grab a copy of Bill Manville's most excellent
utility FindLink from here:

http://www.bmsltd.co.uk/MVP/Default.htm

If the link can be found, FindLink should do so.
 

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

How to find invalid formula references with VBA 2
Problem with external data and #reference error 2
Finding problem source causing "Your formula contains an invalid external reference to a worksheet" 2
How do I copy Chart shee to other workbook without external refere 2
persistent "invalid reference" error message 2
How do I track down 'invalid references' 0
Invalid external reference message 2
External Reference Data Updates. 2

Top