When a budget planner spreadsheet stops working, the cause is almost always one of four things: calculation set to manual, numbers stored as text, the file opened in a read-only or protected view, or a formula range that no longer covers your new rows. Each takes a minute to test, and you can usually tell which one it is by looking at what the totals do when you change a number.
First, what exactly is "not working"?
Planners that people download or open online fail in different ways, and the fix depends on the symptom. Match yours before touching anything.
| What you see | Most likely cause | Quick test |
|---|---|---|
| Totals do not change when you type | Calculation is set to manual | Press F9 in Excel; if totals jump, it was manual |
| A column adds up to zero | Numbers are stored as text | Click a cell; if it is left-aligned or shows a green triangle, it is text |
| You cannot type in cells | Protected view or a locked sheet | Look for a yellow bar saying the file is read-only |
| New rows are ignored | Formula range stops early | Click the total and see which cells are outlined |
| Online version will not load | Browser, extension or sign-in issue | Try a private window |
Fix 1: manual calculation
In Excel, open the Formulas tab and look at Calculation Options. If it says Manual, switch it to Automatic. In Google Sheets this does not apply, because it recalculates on its own; look at the other causes instead. A planner copied from someone else's file can carry the manual setting with it, which is why it feels random.
Fix 2: numbers that are really text
This is the most common culprit when you paste figures from a bank statement or a website. Say your EMI cell shows 7,800 but is stored as text. A formula like =SUM(C2:C10) skips it, and your total spending comes out too low.
- Select the column and set its format to Number rather than Text.
- Retype one cell and see whether it now adds up. If it does, the whole column needs converting.
- To convert in bulk, put =VALUE(C2) in a spare column, fill it down, copy, and paste as values over the originals.
- If the number carries a ₹ sign or a trailing space, use =VALUE(SUBSTITUTE(SUBSTITUTE(C2,"₹",""),",","")) instead.
Why does my total ignore rows I added at the bottom?
Most planners sum a fixed range such as =SUM(C2:C20). If you type a new expense in row 21, it sits outside the range. Either insert new rows in the middle of the list, so the range stretches, or change the formula to a generous range such as =SUM($C$2:$C$500). Spare blank cells do not hurt a sum.
Worked example with made-up numbers
Say your planner shows income of ₹52,000, rent ₹16,000, groceries ₹9,500, transport ₹3,200, EMI ₹7,800 and eating out ₹4,100. Spending adds up to 16,000 + 9,500 + 3,200 + 7,800 + 4,100 = ₹40,600, so what is left is 52,000 - 40,600 = ₹11,400.
Now suppose the sheet claims ₹23,300 is left. The gap is 23,300 - 11,400 = ₹11,900, and 7,800 + 4,100 = 11,900 exactly, so the EMI and eating-out cells are being skipped. That points straight at two cells stored as text. A gap that matches the sum of specific rows is the quickest clue you will get.
What if the planner is an online tool, not a file?
- Reload in a private window to rule out extensions and stored data.
- Try another browser or your phone to see whether the problem follows the device.
- Do not paste bank logins, card numbers or OTPs into any planner.
- Copy your figures out before you clear browser data, because online tools often keep entries only in the browser.
When a sheet stops being enough
Some people outgrow a planner because typing every expense becomes the real problem. SpendixAI lets you upload bank statements in PDF, CSV or Excel, review the rows and categorise them, so the totals come from your records rather than from formulas you have to maintain. If your planner works again after the checks above, that is a perfectly good way to carry on.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

