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?

You want to start by doing EditFind to locate the link, then remove it.

also, it's possible that you have some code there. Right-click on yoru tab
and seelct View Code to see if the link is there...

If what you have is a hyperlink, it would not show in Edit/Links....

"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?

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

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

First, did you try Bill Manville's FindLink program? If no, then try that
first.

Second...

I've never created a reference to a file on a web page, so I'm not even sure
it's possible...

But open your workbook
Go into the VBE (Alt-f11 is a quick way)
Make sure your workbook's project is active
Tools|References

Do you see anything that refers to that file on the web page?



wsleepywil wrote:

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


--

Dave Peterson