Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden external data link
I have an Excel 2003 spreadsheet, built out of an old one that
originally had external data queries that were first opened from inside macros that called up a series of IQY files. I understand that an IQY file is only needed for the very first enquiry, thereafter the query is "embedded" somewhere. The macros have long been deleted, the IQY files have long been deleted. But the links are still there in some place on the spreadsheet which I cannot find. I cannot use the External Data toolbar to track these down. I cannot see anything in the VBA code. Every time I open the file I am presented with a MsgBox regarding Enabling or Disabling automatic refresh for these queries. How may I delete these queries- there are 150 of them somewhere in this spread sheet. Geoff Lambert |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden external data link
Hi Geoff Have you checked in InsertNamesDefine? I frequently have names here that reference external sources. If you no longer need them, they can be deleted. Hope this helps! Richard -- RichardSchollar ------------------------------------------------------------------------ RichardSchollar's Profile: http://www.officehelp.in/member.php?userid=5248 View this thread: http://www.officehelp.in/showthread.php?t=1271116 Posted from - http://www.officehelp.in |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden external data link
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden external data link
Have you tried Edit, Links and then Break Links Button and follow prompts
Saruman "Geoff Lambert" wrote in message ... I have an Excel 2003 spreadsheet, built out of an old one that originally had external data queries that were first opened from inside macros that called up a series of IQY files. I understand that an IQY file is only needed for the very first enquiry, thereafter the query is "embedded" somewhere. The macros have long been deleted, the IQY files have long been deleted. But the links are still there in some place on the spreadsheet which I cannot find. I cannot use the External Data toolbar to track these down. I cannot see anything in the VBA code. Every time I open the file I am presented with a MsgBox regarding Enabling or Disabling automatic refresh for these queries. How may I delete these queries- there are 150 of them somewhere in this spread sheet. Geoff Lambert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula wont do its job on External Data Query | Excel Discussion (Misc queries) | |||
How to do Edit Query from Import External Data. | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Help - external data | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |