Fix Excel Restarting When Running a VBA Macro After a Microsoft 365 Update
Question details
The user needs Excel to run a worksheet-cataloging VBA macro without closing and restarting after a Microsoft 365 update.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- Windows; version not provided
- Scenario
- A VBA macro catalogs worksheets, creates a summary workbook, calculates external-reference formulas, and converts the results to values.
- Observed behavior
- Excel closes and restarts when the macro runs after a Microsoft 365 update.
Confirm that the macro and its source workbooks are trusted, and check that the external workbooks or paths used by the formulas are accessible. Close other Office applications before repairing or reinstalling Microsoft 365.
Run an Online Repair of Microsoft 365
Use Online Repair to address a potentially damaged Office installation before reinstalling it.
Open Windows Settings and go to Apps, then Installed apps or Apps & features.
Find Microsoft 365, select its menu or entry, and choose Modify. Approve the Windows permission prompt if it appears.
Select Online Repair, choose Repair, and follow the prompts. Keep your internet connection available until the repair finishes.
Open Excel and run the trusted macro again using the same source workbooks and external-reference paths.

Uninstall and Reinstall Microsoft 365
Try a complete reinstall if Online Repair does not stop Excel from restarting.
Isolate the Macro Operation That Triggers the Restart
Use a test copy to identify whether worksheet processing, external-reference calculation, or value conversion triggers the restart.
Work with Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files. Its format support can make moving everyday spreadsheet work easier, although it does not repair Excel or guarantee that an Excel VBA macro will run unchanged.

Frequently Asked Questions
Why does Excel restart when my macro runs after an update?
The cause is not established in this case. An Office installation issue, a macro operation, or an external-reference calculation may need investigation. Start with Online Repair, then test the macro in stages if the restart continues.
Where can I find Online Repair for Microsoft 365?
In Windows, open Settings > Apps > Installed apps or Apps & features. Find Microsoft 365, choose Modify, and select Online Repair.
Should I delete the AppModel registry key to fix the crash?
Not as a routine fix. Although the reported case included that registry change, it can affect Windows components. Consult Microsoft Support before making system-wide registry changes.
How can I check which part of the macro causes the restart?
Save a test copy with File > Save As, open the VBA editor with Alt+F11, and test the worksheet cataloging, external-reference calculation, and value-conversion stages separately.
Will WPS Office run my Excel VBA macro unchanged?
Do not assume the macro will run unchanged. VBA support can depend on the WPS edition and the features used by the macro, particularly Excel-specific automation and external references. Test compatibility before relying on it.




