View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marc T Marc T is offline
external usenet poster
 
Posts: 25
Default Change data source for MS Query

Hi Tony,

within Excel, go to 'Edit Query' to bring up the MS Query screen, then
select 'Table Definition...' from the menu. This will bring up a 'Choose Data
Source' window in which you can choose the new location.

Marc

"TonyL" wrote:

Hi

I have a query in an Excel spreadsheet I needed to move the data source to a
new location. I have done this before where I went to edit the query in the
spreadsheet & I get an error message stating that the data source cannot be
found then I was given the opprortunity to point to the new location. This
time it does not give me that option. How else can I change the data source
location? Thanks
--
Tony