| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Supress Query Refresh dialog on opening workbook
I have a workbook with 3 data import queries linked to a database via an
ODBC driver. One of the queries uses parameters, the others do not. The queries are all set not to automatically refresh on opening, but every time I open the workbook I get the Query Refresh dialaog with the option to enable/disable automatic query refresh. How do I supress the display of this dialog? I have tried putting a macro to do this in the wokrbook_open event. This does not work. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Supress Query Refresh dialog on opening workbook
This has been bugging me for some time. I have seen a few messages on this
but no one had been able to answer this. I finally managed to track it down in a MS article: http://support.microsoft.com/default.aspx?id=248204 HTH -- Tony "Paul Tugwell" wrote: I have a workbook with 3 data import queries linked to a database via an ODBC driver. One of the queries uses parameters, the others do not. The queries are all set not to automatically refresh on opening, but every time I open the workbook I get the Query Refresh dialaog with the option to enable/disable automatic query refresh. How do I supress the display of this dialog? I have tried putting a macro to do this in the wokrbook_open event. This does not work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dialog box upon opening workbook | Excel Worksheet Functions | |||
| Automatically refresh XML Maps when opening a workbook | Excel Discussion (Misc queries) | |||
| Disable Query Refresh warning dialog box in Excel 2003 | Excel Discussion (Misc queries) | |||
| How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
| Supress SaveAs dialog box? | Excel Programming | |||
Linear Mode
