Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off XML Prompt when saving Excel files in Office 2007 to 2003 | Excel Discussion (Misc queries) | |||
Updated to Office 2007 - Saving Excel file error | Excel Discussion (Misc queries) | |||
Saving from Excel to MS Office Drawing Object | Excel Discussion (Misc queries) | |||
Properties on Excel Worksheet and definitions | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) |