Template Issues

How to Set the Excel Office 2007–2010 Color Theme for New Workbooks

Muhammad TalhaMuhammad Talha Nov 13, 2026 869 views

Question details

The user wants every new Excel workbook to open with the Office 2007–2010 color theme instead of applying it manually each time.

Product
Microsoft Excel
Device & OS
Windows
Scenario
The user needs a consistent classic Office color theme in all new workbooks without changing the Colors setting for each file.
Observed behavior
Excel does not provide a direct global switch for new workbook color themes, so new workbooks keep the default theme until a template is placed in the XLStart folder.
Before you start

Enable hidden files and folders in File Explorer so you can find the AppData\Roaming\Microsoft\Excel\XLStart path, and close Excel before copying the template into the startup folder.

Solution 1Recommended

Apply the Office 2007–2010 theme automatically with an XLStart template

Use this method when you want every new Excel workbook to open with the Office 2007–2010 color theme without changing it manually.

Excel loads workbook templates from the XLStart folder each time it starts. Saving a workbook that already has the Office 2007–2010 theme as a template in that folder applies the theme to new blank workbooks.

1
Create a workbook and select the theme

Open Excel and create a new blank workbook. Go to Page Layout > Colors and select Office 2007–2010 from the color theme list.

2
Save the file as an Excel template

Click File > Save As, choose Excel Template (*.xltx) as the file type, name the file Office2007-2010.xltx, and save it to the Custom Office Templates folder or another accessible location.

3
Copy the template

Open File Explorer, locate the Office2007-2010.xltx file, and copy it.

4
Place the template in the XLStart folder

Navigate to C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLStart and paste the template there. If the folder is not visible, enable hidden items from the View tab.

5
Restart Excel and verify

Restart Excel, create a new blank workbook, and check that the Office 2007–2010 color theme is applied automatically.

Theme applied to new workbooks: New blank workbooks will now use the Office 2007–2010 color theme automatically.
Free Microsoft Office alternative

Use WPS Office Spreadsheets as a Free Excel Alternative for Template Workflows

If you regularly work with Excel templates but want a free, lightweight office suite, WPS Office Spreadsheets offers a familiar ribbon interface, opens and saves Excel files with high compatibility, and makes it easy to manage workbook formatting without a subscription.

  1. 1. Download WPS Office: Visit the official WPS website and download WPS Office Free for your version of Windows.
  2. 2. Open your Excel workbook: Launch WPS Spreadsheets and open the Excel workbook or template file you want to work with.
  3. 3. Review formatting and save: Use the Page Layout or Design tab to review theme and color options, then save the file in WPS Spreadsheets or export it back to an Excel format.
Work with workbook templates and themed colors in a familiar spreadsheet layoutOpens, edits, and saves Microsoft Excel .xlsx and template files with high compatibilityFree and lightweight office suite with no subscription requiredFamiliar ribbon-based interface makes migration from Microsoft Excel easy
microsoft office alternative - wps office

Frequently Asked Questions

Where is the Excel XLStart folder on Windows?

Navigate to C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLStart. You can also paste %AppData%\Microsoft\Excel\XLStart into the File Explorer address bar, and enable hidden items if needed.

Will this method change the theme of existing workbooks?

No. The template only affects new blank workbooks that Excel creates at startup. Existing .xlsx files keep the theme stored in each workbook.

Can I use a different color theme for new workbooks?

Yes. Choose any theme under Page Layout > Colors, save the workbook as an .xltx template, place it in the XLStart folder, and restart Excel.

What if the Office 2007–2010 theme is not listed in Excel?

The theme is available in Excel versions that include that color set. If it is missing, choose the closest available theme before saving the template, or check your Office version and installation options.

Does WPS Office support the Excel XLStart folder method?

The XLStart startup folder is a Microsoft Excel feature. WPS Office Spreadsheets can open and save Excel files and provides its own template and theme settings for creating default workbook formatting.