Uninstall & Reinstall Issues

What Microsoft Office Online Repair Does to Templates and Macros

John WilsonJohn Wilson Nov 13, 2026 868 views

Question details

Understand how Office Online Repair may affect custom templates and macros and how to protect them before repair.

What Office Online Repair Does to Custom Templates and Macros
Product
Microsoft Office
Device & OS
not provided
Scenario
A user plans to run Online Repair to fix Office application problems and wants to preserve custom files.
Observed behavior
The goal is to repair Office while retaining custom templates, macros, and other settings.
Before you start

Make sure you have an internet connection for Online Repair. Locate your custom templates and macro-enabled files, including any saved outside the default Office folders.

Solution 1Recommended

Back Up Customizations Before Running Office Online Repair

Use this approach to protect templates and macros while repairing the Office installation.

Online Repair effectively reinstalls Office program files. It may reset some settings or customized files, but it does not necessarily remove every template or macro.

1
Copy Word templates

Close Office applications, open File Explorer, and enter %appdata%\Microsoft\Templates in the address bar. Copy Normal.dotm and any custom templates to a separate folder.

2
Save macro files

Copy documents and templates that contain macros, such as .docm and .dotm files. If you use Excel's Personal Macro Workbook, check %appdata%\Microsoft\Excel\XLSTART and copy PERSONAL.XLSB if present.

3
Export VBA modules

In an Office application, press Alt+F11 to open the VBA editor. In Project Explorer, right-click each custom module and select Export File; repeat for any forms or class modules you need.

4
Run Online Repair

In Windows Settings, open Apps, find Microsoft Office or Microsoft 365, and select Modify. Choose Online Repair, then select Repair and follow the prompts.

5
Check and restore customizations

After repair, open the Office apps and test your templates and macros. If needed, close the apps and copy the saved files back to their original locations, or use File > Import File in the VBA editor to restore exported modules.

Back Up Customizations Before Running Office Online Repair
Restore selectively: If a damaged Normal.dotm caused the original problem, replacing the newly created file with the old one could bring the problem back. Restore only the customizations you need where possible.
Free Microsoft Office alternative

Work With Office Templates in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents and templates. It can help you move everyday document work to another suite, but it does not repair Microsoft Office or guarantee compatibility with VBA macros.

Open and edit common Microsoft Word and Excel file formats, including DOCX and XLSXCreate documents using WPS templatesUse a familiar interface for everyday office tasksMove existing documents to a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Does Online Repair always delete Normal.dotm?

No. Online Repair does not necessarily delete Normal.dotm, but settings or customized files can be reset. Copy the file from %appdata%\Microsoft\Templates before repairing Office.

Where are my Excel personal macros stored?

They are often stored in PERSONAL.XLSB. In File Explorer, check %appdata%\Microsoft\Excel\XLSTART and copy the file if it exists.

How can I restore an exported VBA module?

Open the relevant document or template, press Alt+F11, select the project in the VBA editor, and choose File > Import File. Select the module you exported before repair.

What if my templates are stored in another folder?

Copy them from that folder as well. In Word, you can check File > Options > Advanced > File Locations for the user templates location.