What Microsoft Office Online Repair Does to Templates and Macros
Question details
Understand how Office Online Repair may affect custom templates and macros and how to protect them before repair.

- 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.
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.
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.
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.
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.
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.
In Windows Settings, open Apps, find Microsoft Office or Microsoft 365, and select Modify. Choose Online Repair, then select Repair and follow the prompts.
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.

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.

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.




