A household expense file gets slow for four main reasons: volatile formulas that recalculate on every edit, formulas that scan whole columns, receipt images embedded in cells, and years of rows in one tab. Clear those in order and most files recover. If they still crawl, a database-backed tool is the better home for the data.
What makes an expense file slow?
- Volatile functions: TODAY, NOW, OFFSET, INDIRECT and RAND recalculate whenever anything changes. One OFFSET in each of 5,000 rows is a lot of work.
- Whole-column ranges inside array-style formulas, especially SUMPRODUCT over A:A or C:C. The sheet has over a million rows to scan.
- Embedded receipt pictures: photos pasted into cells can make a file many megabytes in size.
- Years of data in one tab with many lookups. Each VLOOKUP over thousands of rows adds up.
- Excess formatting and conditional rules that were copied down far beyond the data.
How do you find the cause?
- Look at the file size in File Explorer. A file with a few thousand rows should be small; a file of many megabytes has pictures or heavy formatting.
- Press Ctrl+End. If the cursor lands far below your last row, the sheet's used range is inflated and needs cleaning.
- Switch calculation to manual (Formulas, Calculation Options, Manual) and edit a cell. If it becomes fast, formulas are the cause. Press F9 to recalculate, and set it back to automatic afterwards.
- Copy the file, delete the receipt pictures in the copy and compare sizes.
What are the clean-up steps?
- Replace TODAY and NOW in every row with one cell that holds the date, and refer to that cell.
- Replace OFFSET and INDIRECT with direct ranges. Use =SUMIFS($C$2:$C$5000,$B$2:$B$5000,E2) with a fixed range instead of a whole column.
- Paste older months as values, so those rows no longer calculate.
- Move receipt pictures into a folder and store a file name or link in the sheet.
- Select the empty rows and columns below and to the right of your data, delete them, then save. This resets the used range.
- Split the file: keep the current year in the live sheet and past years in an archive file.
Check conditional formatting too. In Excel, Home, Conditional Formatting, Manage Rules, with the scope set to This Worksheet, often lists dozens of copies of the same rule created by copy-paste. Delete the duplicates and merge them into one rule with a wide range.
What about Google Sheets?
The same ideas apply. Avoid very long formulas in every row, avoid IMPORTRANGE chains between many files, and clear unused columns. Google Sheets also caps the number of cells in a file, so a file with many mostly empty columns can run into that limit; check the current limit in Google's help rather than assuming.
A worked example of a quiet slow-down
Say column D in 5,000 rows holds =IF($A2<TODAY()-30,"Old","New"). TODAY is volatile, so every edit anywhere recalculates all 5,000 formulas. Put =TODAY() once in cell G1 and change the row formula to =IF($A2<$G$1-30,"Old","New"). The result is the same, but the sheet now evaluates TODAY once, and typing a new expense feels instant again. Find the same pattern with NOW, OFFSET and INDIRECT and replace them in the same way.
When is it time to move on?
When you have cleaned the file and it is still slow, or when you must keep years of detail and receipts in one place, the file format itself is the limit. A tool that keeps transactions in a database and receipts as attached files does not need your sheet to recalculate every row. SpendixAI keeps receipts with their transactions, takes statement uploads rather than typed rows, and Pro allows 2,000 transactions a month in one personal workspace. You give up custom formulas, so keep the archived sheet for anything unusual.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

