When a downloaded spreadsheet template stops working, the cause is nearly always one of five things: the file opened in Protected View, calculation is set to manual, dates are stored as text, a macro is blocked, or a function does not exist in the program you opened it in. Check them in this order.
Fix one: editing is blocked
If the sheet will not let you type, Excel may have opened it in Protected View because it came from a download. Use the Enable Editing button at the top, once you trust where the file came from. Some templates also have protected sheets, where certain cells are locked on purpose. The template's own notes should say whether there is a password for editing, so read them and do not use tools that break protection.
Fix two: formulas show old numbers
In Excel, go to the Formulas tab, then Calculation Options, and choose Automatic. Press F9 to force a recalculation. If a cell shows a formula as text, the cell was formatted as Text, so change it to General and re-enter the formula.
Fix three: dates and amounts stored as text
This is the most common reason a SUMIFS or monthly total shows zero. Test with a spare cell:
- =ISNUMBER(A2) returns TRUE for a real date or number and FALSE for text
- =VALUE(C2) converts a text amount such as 1250 into a number
- =DATEVALUE(A2) converts text like 05/03/2026 to a date, but the result depends on your regional date settings
After converting, paste the values back over the originals. Amounts copied from a PDF may carry hidden spaces or the rupee sign, which =VALUE(TRIM(SUBSTITUTE(C2,"₹",""))) strips.
Fix four: macros and add-ins
A template with macros is saved as a macro-enabled workbook. If macros are blocked, Excel will say so in a bar at the top. Enable them only if you trust the source. Without macros, buttons and automatic features will do nothing, though normal formulas should still work.
Fix five: it works in Excel but not in Google Sheets
| Symptom | Likely cause | What to try |
|---|---|---|
| #NAME? error | Function not supported where you opened the file | Check the function name, or reopen in Excel |
| Buttons do nothing | Macros are not run in Sheets | Use Excel, or replace the macro steps by hand |
| Odd formatting | Styles differ between programs | Reapply formats |
| #REF! after deleting columns | A formula pointed at a removed cell | Undo, or rewrite the formula |
A formula check you can copy
To total one category for a month, with dates in A2:A500, categories in B2:B500, amounts in C2:C500, month start in E1 and next month start in E2:
- =SUMIFS($C$2:$C$500, $B$2:$B$500, "Food", $A$2:$A$500, ">="&$E$1, $A$2:$A$500, "<"&$E$2)
Say Food rows are ₹320, ₹1,450 and ₹680 in the month. The result must be 320 + 1,450 + 680 = ₹2,450. If you get zero, test the dates and the spelling of the category, since a trailing space makes "Food " different from "Food".
Before you give up on the file
If a template is breaking only because your data does not fit its layout, consider simplifying. A sheet with six columns that you understand is worth more than a polished template with forty that you do not. Keep one tab for raw entries, one for monthly summaries built with SUMIFS, and nothing else. Copy the formulas down only as far as your data goes, use fixed ranges such as $A$2:$A$500, and add a check cell that compares the total of your summary with the total of the raw entries, so any gap is visible at once.
- Save a copy before changing anything.
- Try the file on another computer or in another program.
- Check the template's own help notes and the site's help page, as we cannot see its documentation.
- Rebuild the one broken formula instead of the whole sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


