I’ve discovered that we can reduce the Tiller-Foundation-Template.xlsx file size by over 6MB without sacrificing functionality. This enhancement can potentially improve:
- File load/launch time.
- Navigation experience and performance.
- File close time, especially when saving to OneDrive, which sometimes struggles with large files.
The primary cause of the large file size is the “Monthly Budget” sheet, making up 90%+ of the total file size. By recreating this sheet, you can significantly reduce the file size to around 300kb (for a fresh install) and maintain a leaner workbook even with lots of transactions and add-ons – my workbook with 1,500 transactions and many add-ons is 750kb.
- Download the revised Monthly Budget workbook .
- Remove the existing “Monthly Budget” tab from your workbook (you may want to back up first).
- If you can’t find the tab, it might be hidden; please unhide it to locate it.
- Follow this guide to copy the downloaded template into your Excel workbook and to connect the formula references to your local workbook data.
If you find any errors with the standard installation, particularly when using community add-ons, follow these steps to manually create a new “Monthly Budget”:
- Create a new sheet named “Sheet1” where you will copy the necessary data and formulas from “Monthly Budget.”
- Unhide and activate the “Monthly Budget” tab.
- Use the “Name Box” to type “A1:AF516” and copy the selection (see screenshot below for guidance).
- Switch to “Sheet1” and paste the selection.
- Adjust formatting as needed:
- Apply “Column Widths” using Paste Special.
- Hide unnecessary columns and disable “Gridlines” in the “View” Ribbon.
- Match the row heights with the original sheet (it might be a bit tedious for rows 1-13. Set to height “20” for Row 14+).
- Delete the old “Monthly Budget” tab and rename “Sheet1” to “Monthly Budget.”
Screenshot of Step 3: “Name Box”:
Feel free to copy, use, and modify. I hope to see this improvement incorporated into the standard download.
- You might also consider removing the “Install Help” tab for an additional 300kb reduction if you haven’t already.
- I’ve observed this issue in worksheets as far back as August 22, 2022. It might not affect earlier workbooks, but unfortunately, I can’t verify.