Saving Query definitions in Excel (Office XP pro)

[Steve]

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?

 

[Mystic]

I've discovered that this problem only occurs when the auto refresh is set
in the query definitions for more than one query in the same worksheet.