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? |
Saving Query definitions in Excel (Office XP pro)
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. "Steve" wrote in message ... 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? |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com