Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem disabling/avoiding refreshall popup
If an Excel spreadsheet has query attached, when you open Excel, it puts up a
pop-up "query refresh" which requires an selection of "enable automatic refresh" or "disable automatic refresh". How can I disable this pop-up, or make a selection automatically (maybe using sendkey, or using Excel.applicaton in VBA)? I do not have authority because local policy is set (security) to change the registry, and another user cannot make the registry fix because the change in the current user area of the registry. I desire to run this spreadsheet, dynamically changing the date, and thus need to update the data in a run. Then email the spreadsheet to users who do not have access to the query source tables. Too bad Microsoft got rid of the don't show the window again option. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200611/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with ThisWorkbook.RefreshAll | Excel Discussion (Misc queries) | |||
ActiveWorkbook.RefreshAll | Excel Programming | |||
Disabling the CONTROL + BREAK shortcut key function - HAVING PROBLEM - MY CODE DOES NOT WORK | Excel Programming | |||
ActiveWorkbook.RefreshAll | Excel Programming | |||
Disabling popup boxes | Excel Programming |