#1   Report Post  
 
Posts: n/a
Default 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   Report Post  
Bill Manville
 
Posts: n/a
Default

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

  #4   Report Post  
Bill Manville
 
Posts: n/a
Default

<blush

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cut links between worksheets in same workbook Houndstooth Excel Worksheet Functions 1 June 7th 05 11:36 AM
Ghost links in Workbook ASinghBama New Users to Excel 2 May 24th 05 09:29 PM
Reoccurring Edit Links Error Spyder Excel Discussion (Misc queries) 6 April 12th 05 02:30 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM
Links in formulas change when another user runs a workbook L Mehl Excel Discussion (Misc queries) 2 November 27th 04 10:27 PM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"