Formatting Issues

Fix Excel Custom Theme Colors Not Persisting After Closing

Amos GikundaAmos Gikunda Nov 4, 2026 869 views

Question details

Users experience an issue where custom colors added to a THMX theme file disappear from Microsoft Excel after closing the application, despite working correctly in Word and PowerPoint.

Fix Excel Custom Theme Colors Not Persisting After Closing
Product
Microsoft Excel
Device & OS
not provided
Scenario
Applying custom THMX theme colors to format an Excel workbook.
Observed behavior
Custom theme colors fail to persist and revert or disappear once the Excel workbook or application is closed and reopened.
Before you start

Verify that your THMX file is saved in the correct Document Themes folder and test whether the color dropping issue also occurs in a completely new workbook.

Solution 1Recommended

Report the Theme Bug via Excel Feedback

Since this is a known application behavior issue with theme1.xml and custom palettes in Excel, submitting detailed feedback helps the product team investigate and deploy a fix.

Microsoft uses user feedback to track and resolve ongoing bugs with how Excel reads external THMX files upon reopening. Reporting your specific environment details accelerates this process.

1
Open the Feedback Menu

Launch Microsoft Excel and click on 'File' in the top-left corner of the ribbon, then select 'Feedback' from the bottom of the left-hand navigation pane.

2
Report the Problem

Click on 'Report a Problem' or 'Send a Frown' depending on your specific Office version.

3
Provide Detailed Information

Describe the issue clearly, noting that THMX custom colors disappear after closing. Be sure to include your Office version, reproduction steps, and state if it happens in new workbooks.

Report the Theme Bug via Excel Feedback
Feedback Tracking: Microsoft support teams usually post updates directly to the feedback item once the responsible team has reviewed the theme1.xml behavior.
Free Microsoft Office alternative

Try WPS Office for Reliable Spreadsheet Formatting

If Microsoft Excel's theme bugs are disrupting your workflow, WPS Office offers a highly compatible, lightweight, and free alternative. It handles document themes and custom formatting seamlessly, ensuring your spreadsheet designs look exactly the same every time you open them.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file without losing any formatting.
  3. 3. Apply Custom Colors: Navigate to the Page Layout tab to securely apply and save your custom color palettes.
Fully compatible with Microsoft Excel (.xlsx) formats and standard theme filesReliable custom color palette and formatting retention across sessionsLightweight installation with a familiar, easy-to-use interfaceCompletely free to download and use for your daily office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why do custom theme colors work in Word but not Excel?

Excel parses and handles the theme1.xml architecture and custom color palettes slightly differently than Word and PowerPoint. This discrepancy often results in bugs where Excel drops the external THMX formatting upon reopening.

Where should THMX files be saved for Office applications?

For Office applications to recognize them properly by default, THMX files should be saved in the Document Themes folder, typically located at %appdata%\Microsoft\Templates\Document Themes on Windows.

Can I lock theme colors by using an Excel template?

Yes, saving your workbook as an Excel Template (.xltx) with the custom colors defined directly in the file (rather than linked to an external THMX) can help preserve the color palette for all future files generated from that template.

Will running an Office Repair fix this theme issue?

Because this is typically a core software bug related to how Excel reads the THMX file across sessions rather than a corrupted installation, a standard Office repair usually does not resolve it. Reporting the issue directly to Microsoft is the best course of action.