Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Refresh
I have created a template that has drop down lists. These lists are external
data sets from a SQL database. When I protest the worksheet it does not allow the refresh. Second, is there a way for the refresh to be done without the user being prompted? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Refresh
You could assign a macro to the Workbook_Open event in the Excel file that
uprotected the worksheets, refreshes the data links and then reprotects the file. If you're using MS Query to query your database you can save the query and have it update on open automatcally, but you might have to unprotect the worksheet first. -- Kevin Backmann "Jim" wrote: I have created a template that has drop down lists. These lists are external data sets from a SQL database. When I protest the worksheet it does not allow the refresh. Second, is there a way for the refresh to be done without the user being prompted? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Query Refresh | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
2003 Automatic Query Refresh | Setting up and Configuration of Excel | |||
How to Diable automatic query refresh? | Setting up and Configuration of Excel | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) |