problem with: hidden (invalid) external reference
 

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

problem with: hidden (invalid) external reference
 

On Sun, 25 Jan 2004 09:18:09 GMT, "Peter van de Kerkhof"
wrote:

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

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

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

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


---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *