Removing a hidden link to an extern worksheet

Hi

I got a problem when opening an Excel application (workbook). When
opening it always asks for a linked extern worksheet to open to update
(actualize) the data in the sheet. Formerly there was a formula with a
link to an extern worksheet. But I removed that formula already. So
there are no more referrals to extern sheets at all.
There must be two reasions for that: There is a referral in a formula I
can't find. So how to find it (the application is quite big).
Or the question appears by mistake and there isn't any link at all. But
how to remove that.
When I go to the menu 'Edit - Links' there is an option 'Update
Automatically' or 'Manually', but the button 'Manually' isnt active, so
I cannot change that. The link entry (name of the worksheet Excel is
looking for) appears in the link list, and when I remove the link entry
it will be appear again, when I open the menu again. So I cannot remove
it here.

How can I remove that link ?

Siggy.


---
Message posted from http://www.ExcelForum.com/

Hi
maybe the following add-in will help you:
http://www.bmsltd.co.uk/DLCount/DLCo...e=FindLink.zip

Frank

Hi

I got a problem when opening an Excel application (workbook). When
opening it always asks for a linked extern worksheet to open to
update
(actualize) the data in the sheet. Formerly there was a formula with
a
link to an extern worksheet. But I removed that formula already. So
there are no more referrals to extern sheets at all.
There must be two reasions for that: There is a referral in a formula
I can't find. So how to find it (the application is quite big).
Or the question appears by mistake and there isn't any link at all.
But how to remove that.
When I go to the menu 'Edit - Links' there is an option 'Update
Automatically' or 'Manually', but the button 'Manually' isnt active,
so I cannot change that. The link entry (name of the worksheet Excel
is looking for) appears in the link list, and when I remove the link
entry it will be appear again, when I open the menu again. So I
cannot remove it here.

How can I remove that link ?

Siggy.

Hi Frank,
I tried this Findlink tool and the following message comes:

''I cant accress datalabel 30 of series 4 of chart 1 on Diagram.
Possibly it contains the link you are looking for, you will need to
check it yourself.''

The tool also destroys (changes) my chart formatting in many ways while
running.
If there is the hidden link how can I find that in the chart. In that
chart I dont find any link to an extern file at all. There is only one
datalabel. How can I see the formula behind it, I can only see the
formula behind the whole curve (Series 4) to which the datalabel
belong to.


Siggy




Frank Kabel wrote:
*Hi
maybe the following add-in will help you:
http://www.bmsltd.co.uk/DLCount/DLCo...e=FindLink.zip

Frank

Hi

I got a problem when opening an Excel application (workbook). When
opening it always asks for a linked extern worksheet to open to
update
(actualize) the data in the sheet. Formerly there was a formula
with
a
link to an extern worksheet. But I removed that formula already.
So
there are no more referrals to extern sheets at all.
There must be two reasions for that: There is a referral in a
formula
I can't find. So how to find it (the application is quite big).
Or the question appears by mistake and there isn't any link at
all.
But how to remove that.
When I go to the menu 'Edit - Links' there is an option 'Update
Automatically' or 'Manually', but the button 'Manually' isnt
active,
so I cannot change that. The link entry (name of the worksheet
Excel
is looking for) appears in the link list, and when I remove the
link
entry it will be appear again, when I open the menu again. So I
cannot remove it here.

How can I remove that link ?

Siggy. *


---
Message posted from http://www.ExcelForum.com/

Hi Frank,
I tried this Findlink tool and the following message comes:

''I cant accress datalabel 30 of series 4 of chart 1 on Diagram.
Possibly it contains the link you are looking for, you will need to
check it yourself.''

The tool also destroys (changes) my chart formatting in many ways
while running.
If there is the hidden link how can I find that in the chart. In that
chart I dont find any link to an extern file at all. There is only
one
datalabel. How can I see the formula behind it, I can only see the
formula behind the whole curve (Series 4) to which the datalabel
belong to.

Hi
tra the following:
- right click on your chart
- select data source
- check the formulas (maybe there is a reference to a different
workbook)

Frank