View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
StormKatt StormKatt is offline
external usenet poster
 
Posts: 1
Default How do I change the datasource location for a query in Excel 2003

I am trying to recreate a report that went wrong for last month, and to do
so, I have to rename the original database so as not to corrupt it. This
means I need to have the Excel template temporarily point to the renamed
database so as to refresh the data using the results from the recovered
database. There has to be an easier way than completely recreating the
spreadsheet to get it to point to the new location of the Access data source.