MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Changes to Book Template are Cumulative


March 04, 2019 - 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


Bill Jelen is the author / co-author of
Microsoft Excel 2019 Pivot Table Data Crunching

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.