MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Changes to Book Template are Cumulative


February 13, 2020 - by Bill Jelen

Changes to Book Template  are Cumulative. Photo Credit: Annie Spratt at Unsplash.com

I‘ve had the opportunity to speak at three consecutive Excelapalooza conferences near Dallas. The conference team arranges two simultaneous tracks about Microsoft Excel. While I am presenting in one ballroom, Lawrence “Mac” McClelland is presenting another track in another ballroom. I picked up this tip from Mac:

Anything you do to Book.xltx (default workbook) is cumulative. Build the workbook with your favorite settings today. If you discover some new settings that you would like to add to Book.xltx in the future, follow these steps:


  1. Press Ctrl+N to open a blank version of Book.xltx.
  2. Make any changes you would like.
  3. Select File, Save As.
  4. Change the file type to XLTX or XLTM, depending on whether you regularly use macros.
  5. Change Folder to the XLStart folder.
  6. Save the file as Book.xltx to replace the existing Book.xltx.
  7. Repeat steps 3–5 and save the file as Sheet.xltx.

Title Photo: Annie Spratt at Unsplash.com


This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.


Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.