Ghost Links
 

Hi,

I have a spreadsheet (on Excel 2000) which used to draw data from
several external data providers. I have cleaned up all reference to one
of them, both in the spreadsheet and in the accompanying macros.

However, everytime I start the spreadsheet I get prompted to load
up/connect to the external provider, even though I have removed all
links to it.

I have checked 'Edit' - 'Links' and there's no link to it anymore.

The option of getting excel to not prompt and automatically update is
not viable as the application it tries to open freezes Excel...

Any idea where the link(s) is/are hiding ?

Thanks in advance

Olivier

It's obviously not a formula link since Edit / Links is disabled.
I guess it's a Query that has been set to automatically refresh on
startup.

Try running this to see if it can be found

Sub FindQueryTables()
Dim WS As Worksheet
Dim QT as QueryTable
For Each WS In Worksheets
For Each QT In WS.QueryTables
WS.Activate
QT.ResultRange.Select
If MsgBox ("Found one: " & QT.Connect & vbNewline &
"Delete?",vbYesNo)=vbYes Then
QT.Delete
End If
Next
Next
End Sub
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Olan,
Just to let you know, Bill is THE MAN IN THE WORLD!!! when it comes to
Excel Links. You've gotten advise from THE BEST. Take it. The entire Excel
community does!
Sincerely,
--
Gary Brown




" wrote:

Hi,

I have a spreadsheet (on Excel 2000) which used to draw data from
several external data providers. I have cleaned up all reference to one
of them, both in the spreadsheet and in the accompanying macros.

However, everytime I start the spreadsheet I get prompted to load
up/connect to the external provider, even though I have removed all
links to it.

I have checked 'Edit' - 'Links' and there's no link to it anymore.

The option of getting excel to not prompt and automatically update is
not viable as the application it tries to open freezes Excel...

Any idea where the link(s) is/are hiding ?

Thanks in advance

Olivier

<blush

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup