View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TonyL TonyL is offline
external usenet poster
 
Posts: 17
Default Change data source for MS Query

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