Cancel opening messages/phantom link issue

[J.W.]

I have a phantom link that i absolutely cannot find. I have tried some
of everything! Is there any way I could just cancel any messages that
are programmed to come up when i open a workbook? - or autmatically
answer no.

(trying to get around always having to answer whether or not I want to
update the information that is linked to another workbook).

thanx

 

[Gord Dibben]

Rather than mask the "links" message, find the links and delete them.

Could be a defined name that is causing the problem.

Download and use Bill Manville's FindLink program:

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


Gord Dibben MS Excel MVP

 

[J.W.]

Tried to delete it and am unsucessful each time. Cannot try the link
below because for some reasons zip files wont work on this pc. I have
tried all 5 recommended steps and still no success. So for my sanity'
sake.... Is there any way to stop the message?

 

[Gord Dibben]

"All 5 steps" were what?

Maybe try Tools>Options>Edit and uncheck "ask to update links"

Can you go to Edit>Links and change the source?

Zip files won't work means what?

Right-click and "extract all" is not available?

Maybe download Winzip and use that.

http://www.download.com/3000-2250-10003164.html


Gord