Untraceable coupling to another sheet
 

Not entirely sure what the correct term in english are, since I'm using
a Dutch version of Excel here at work.

I have the following problem:
In one of my sheets, as soon as I open it Excel asks me if I want to
update with changes made in a different worksheet.
Under "Bewerken-Koppelingen" (I think it would be menu
"edit-couplings"?) there is one file listed. I want to get rid of this
link.

I've tried searching ALL cells in all the sheets for a link to this
file, but none is to be found. I've also checked if I could find some
sort of linked formatting, but to no avail.

Colleagues of mine also report often that they have these
"untraceble/undeletable links/couplings"...

Hope someone can help me out :)

regards,

Maarten


--
Maarten
------------------------------------------------------------------------
Maarten's Profile: http://www.excelforum.com/member.php...o&userid=17648
View this thread: http://www.excelforum.com/showthread...hreadid=472900

Sometimes a Named Range may refer to an external sheet, or a button has
code assigned to it that resides in another spreadsheet. Could that be
the problem?

There is not a single line of VB code in the spreadsheet. I've tried
looking for all named ranges, but all I could find were some printing
ranges (ofcourse none directing to the other document).


--
Maarten
------------------------------------------------------------------------
Maarten's Profile: http://www.excelforum.com/member.php...o&userid=17648
View this thread: http://www.excelforum.com/showthread...hreadid=472900

I had this problem before also. What I did was I saved a back-up copy of the
file and then I deleted on sheet at a time until I was able to identify the
sheet or sheets with the problem. Once you narrow down where the link could
be it. Makes it easier to track, the link could be in a pivot table or chart
that may not be picked up in a search.
--
BrianDon


"Dave O" wrote:

Sometimes a Named Range may refer to an external sheet, or a button has
code assigned to it that resides in another spreadsheet. Could that be
the problem?

I have had that problem several times. If you do not want to see that
message anymo Edit: Links: and turn off the start up prompt for
updating links


--
imjustme
------------------------------------------------------------------------
imjustme's Profile: http://www.excelforum.com/member.php...o&userid=26854
View this thread: http://www.excelforum.com/showthread...hreadid=472900