As you say, i want to keep my links but remove the webpage link. When i try
to open the link i get the message:

Unable to open http://www.devon.gov.uk/dcs/ict/spreds/weather4.xls.

I have looked at the code and there only seems to be code that i have
written.

When i open the workbook with Macros disabled i still get the web link issue.


"Dave Peterson" wrote:

So you want to keep the link to the other workbook, but you want to remove the
link to the web page?

If yes, what does the link to the web page do?

Does it open a browser (MSIE or Firefox or ...) and go to the site?

If yes, then I bet you have a macro (workbook_open or auto_open) that's
following a hyperlink. You could test this by closing this file and re-opening
the workbook with macros disabled.

If that's not it, then maybe Bill Manville's FindLink program will help:
http://www.oaltd.co.uk/MVP/Default.htm

(could it be some query that's trying to retrieve data???)



wsleepywil wrote:

Running Excel 2003. I have developed a workbook based on a previous workbook.
My workbook has a link to another sheet. When i open the workbook it also
tries to link to a webpage that doesn't exist. However the web page doesn't
show as a link when i use edit<links. How can i remove this non existent
link?

--

Dave Peterson