Excel Excel refreshall forces answer to popup

Joined
Nov 13, 2006
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top