How to Set the Excel Office 2007–2010 Color Theme for New Workbooks
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.
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.
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.
Open Excel and create a new blank workbook. Go to Page Layout > Colors and select Office 2007–2010 from the color theme list.
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.
Open File Explorer, locate the Office2007-2010.xltx file, and copy it.
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.
Restart Excel, create a new blank workbook, and check that the Office 2007–2010 color theme is applied automatically.
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. Download WPS Office: Visit the official WPS website and download WPS Office Free for your version of Windows.
- 2. Open your Excel workbook: Launch WPS Spreadsheets and open the Excel workbook or template file you want to work with.
- 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.

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.




