Solution to "Automatic Updates Disabled": Execute Macro QAT in New Excel Doc

This article outlines a solution to enable automatic updates when executing a macro in a new Excel document with "Automatic Updates Disabled."

Context

When you try to open two Excel workbooks and enable automatic updates in one, Excel may not be able to open the second workbook. In such cases, you can execute a macro in a new Excel document to enable automatic updates.

Solution

To enable automatic updates in a new Excel document using a macro, follow these steps:

1. Open a new blank Excel document.
2. Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.
3. Press Insert > Module to create a new module.
4. Copy and paste the following code snippet into the module:

 Sub EnableAutomaticUpdates()
 Application.AutomaticSaveEnabled = True
 Application.AutomaticUpdates.AutoUpdateMethod = xlUpdateAutomatic
 Application.AutomaticUpdates.UpdateMode = xlUpdateNotify
 Application.AutomaticUpdates.UpdateFrequency = xlUpdateFrequencyDaily
 Application.AutomaticUpdates.UpdateInterval = 1
 End Sub
 

5. Save the macro with a descriptive name, such as "EnableAutomaticUpdates."
6. Close the VBA editor.
7. In the new Excel document, press Alt + F8 to open the Macro dialog box.
8. Select the "EnableAutomaticUpdates" macro and click "Run."

After running the macro, automatic updates will be enabled in the new Excel document.

References

For further information on Excel VBA and automating tasks, check out:

• Microsoft Excel VBA
• Enable or disable automatic updates for Excel