Office Settings & Configuration

How to Use a Saved Excel Theme File Across Multiple Computers

Ayan MasoodAyan Masood Nov 10, 2026 869 views

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.

How to Use a Saved Excel Theme File Across Multiple Computers
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Document Themes Folder

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.

2
Copy the Theme File

Locate your saved .thmx file in your Downloads or Documents folder, copy it, and paste it into the Document Themes folder.

3
Apply in Excel

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.

Save the Theme File to the Default Document Themes Folder
Pro Tip: Once the theme is applied, you can click 'Themes' and select 'Save Current Theme' to quickly back it up or rename it directly from Excel.
Customize Your Spreadsheets with WPS Office

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. 1. Open WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
  2. 2. Navigate to Page Layout: Click on the 'Page Layout' tab located in the top ribbon.
  3. 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.
Highly compatible with Microsoft Excel formats (.xlsx, .xls) and theme structuresFree, lightweight, and fast to launch on any deviceBuilt-in rich color palettes and formatting tools for professional spreadsheetsCloud synchronization to access your templates across multiple computers
QA img-9

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.