VBA & Macro Problems

Fix Excel Restarting When Running a VBA Macro After a Microsoft 365 Update

Algirdas JasaitisAlgirdas Jasaitis Nov 20, 2026 869 views

Question details

The user needs Excel to run a worksheet-cataloging VBA macro without closing and restarting after a Microsoft 365 update.

Fix Excel Restarting When Running a VBA Macro 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.
Before you start

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.

Solution 1Recommended

Run an Online Repair of Microsoft 365

Use Online Repair to address a potentially damaged Office installation before reinstalling it.

1
Open installed apps

Open Windows Settings and go to Apps, then Installed apps or Apps & features.

2
Start Office repair

Find Microsoft 365, select its menu or entry, and choose Modify. Approve the Windows permission prompt if it appears.

3
Run Online Repair

Select Online Repair, choose Repair, and follow the prompts. Keep your internet connection available until the repair finishes.

4
Test the macro

Open Excel and run the trusted macro again using the same source workbooks and external-reference paths.

Run an Online Repair of Microsoft 365
Free Microsoft Office alternative

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.

Open and edit spreadsheet workbooks in WPS SpreadsheetsCompatible with common Microsoft Excel formats, including XLSX and XLSFamiliar menus help ease the transition from Microsoft OfficeA free, lightweight suite for everyday document work
microsoft office alternative - wps office

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.