Hi, I currently have a workbook which has around 20 sheets in, most of which I have put queries in which pull data straight from our database. I want to refresh the data at specific intervals myself before sending to users, so I have turned off automatic refresh on each individual query - Data\Import External Data\Data Range Properties and untick refresh on open. However, when the file is sent to users, it comes up with the message asking if you want to disable or enable automatic refresh. I would like it so this is automatically disabled and doesn't even ask the user. Does anybody know if this is possible to do in VBA at all? Obviously I can just ask people to press disable, but don't want the risk of people messing things up at all (they won't have an ODBC connection, so will just get error messages if enable is attempted) and i'd like it as user friendly as possible. Any advice appreciated.
Can I Disable The 'Automatic Refresh' Msg In Excel 2000?(2 posts)
From the Excel Help file:
Control the startup prompt for updating all links
Don't ask whether to update links when I open any workbook, and update links automatically
This option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected. This option also affects links to other programs.
On the Tools menu, click Options, and then click the Edit tab.
Clear the Ask to update automatic links check box. If the box is cleared, the links are automatically updated, and no prompt is displayed.
Don't ask to update links for this workbook, and let me control whether links are updated
Warning This option affects all users of the workbook. If you choose to not update links, and not to prompt, users of the workbook will not know the data is out of date.
On Edit menu, click Links.
Click Startup Prompt.
Select the option you want.
Note You will still be notified if there are any broken links.