View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_44_] Steve[_44_] is offline
external usenet poster
 
Posts: 1
Default Saving Query definitions in Excel (Office XP pro)

I've saved multiple queries in the same workbook several
times in the past. Now with Office XP recently
installed, Excel does not always remember that there are
queries in the worksheet(s). The previous data is there
when you open a saved spreadsheet, but you are unable to
refresh the query ... sometimes it will remember one
query (the last one refreshed before saving) but not all
the queries.

I've tried this on 3 different machines amd moved the
ODBC datasource as well, same result. Anybody else
experience this and may have some insight?