Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
<blush
Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut links between worksheets in same workbook | Excel Worksheet Functions | |||
Ghost links in Workbook | New Users to Excel | |||
Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |