How to Use a Saved Excel Theme File Across Multiple Computers
Question details
The user needs to apply a custom Excel theme (.thmx file) created on one computer to other computers, but it fails to appear in the available theme gallery.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Sharing or importing a custom Excel theme (.thmx file) onto a different computer.
- Observed behavior
- The custom theme does not appear in the available theme gallery even after using the 'Browse for Themes' option.
Ensure you have transferred the .thmx file to the new computer using a USB drive, email, or cloud storage, and note the exact folder where you saved it.
Save the Theme File to the Default Document Themes Folder
Placing the .thmx file in the designated Office themes folder ensures it automatically appears in your theme gallery without needing to browse for it every time.
Microsoft Office automatically populates the theme gallery from a specific system folder. Moving your custom theme there makes it persistent across all your workbooks.
Press the Windows Key + R to open the Run dialog. Type '%appdata%\Microsoft\Templates\Document Themes' and press Enter to open the default themes folder.
Locate your saved .thmx file in your Downloads or Documents folder, copy it, and paste it into the Document Themes folder.
Restart Excel, open your workbook, and navigate to the Page Layout tab. Click 'Themes' and your custom theme will now appear under the 'Custom' section.

Unblock the Downloaded Theme File in Windows
Windows may block files transferred from another computer or downloaded from the internet for security reasons, preventing Excel from loading the theme.
Apply the Custom Theme Manually via Browse
You can manually locate and apply the theme file for a specific workbook if you prefer not to save it to the default system folder.
Apply and Manage Spreadsheet Themes Easily in WPS Office
WPS Office provides a highly compatible and user-friendly interface for managing spreadsheet styles, color schemes, and themes. You can easily share your preferred workbook designs across devices seamlessly.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
- 2. Navigate to Page Layout: Click on the 'Page Layout' tab located in the top ribbon.
- 3. Apply Colors or Themes: Click the 'Colors' or 'Themes' icon to select from a variety of built-in palettes, or import custom settings to instantly update your charts and tables.

Frequently Asked Questions
Why does my custom Excel theme revert to the default font on a new computer?
Themes contain both color palettes and font specifications. If the destination computer does not have the custom font installed, Excel cannot render it and will substitute it with the default system font. Ensure the required fonts are installed on the new machine.
Can I set a custom theme as the default for all new Excel workbooks?
Yes. Apply your custom theme to a blank workbook, then save the workbook as an Excel Template (.xltx) named 'Book.xltx'. Place this template file in your XLSTART folder so that Excel uses it every time a new workbook is created.
Are .thmx files compatible with Word and PowerPoint?
Yes, Office Document Theme (.thmx) files are universally compatible across Excel, Word, and PowerPoint. You can create a theme in PowerPoint and apply the exact same .thmx file in Excel to maintain consistent branding.
Where is the XLSTART folder located?
The XLSTART folder is typically located at 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART'. Saving templates here ensures they load automatically when Excel launches.




