| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ms query refresh
Hi all,
I have an Excel file with three tabs, each tab has a query set up to draw new data each morning. The data comes from a database table which gets freshed every morning. But I am not sure how make it Excel to re-query the external data and draw in the new data from Excel. I set up the queries as follow in the same way for each tab: Data-Import External Data-New Database Query... Thanks for sharing your suggestions. Ben -- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ms query refresh
If you right click on the query and select options or properties, you should
have refresh options of query every "n" minutes and/or query on file open. -- Regards, Tom Ogilvy "Ben" wrote: Hi all, I have an Excel file with three tabs, each tab has a query set up to draw new data each morning. The data comes from a database table which gets freshed every morning. But I am not sure how make it Excel to re-query the external data and draw in the new data from Excel. I set up the queries as follow in the same way for each tab: Data-Import External Data-New Database Query... Thanks for sharing your suggestions. Ben -- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ms query refresh
Tom,
I deleted and re-created the queries. After which I saw the option Data-Import External Data-Data Range Properties..., I changed the update option to [Refresh data on file open]. It worked. Thanks again. Ben -- "Tom Ogilvy" wrote: If you right click on the query and select options or properties, you should have refresh options of query every "n" minutes and/or query on file open. -- Regards, Tom Ogilvy "Ben" wrote: Hi all, I have an Excel file with three tabs, each tab has a query set up to draw new data each morning. The data comes from a database table which gets freshed every morning. But I am not sure how make it Excel to re-query the external data and draw in the new data from Excel. I set up the queries as follow in the same way for each tab: Data-Import External Data-New Database Query... Thanks for sharing your suggestions. Ben -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
| Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming | |||
| Web Query fail to Refresh All but individual refresh is ok | Excel Programming | |||
Linear Mode
