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?