Aspire Budgeting

Spreadsheet is slow or broken

Published on June 11, 2026

If your Aspire spreadsheet is laggy, showing errors, or behaving unexpectedly, here are the common causes and fixes.

Slow performance

Too many rows of data

Google Sheets slows down as data grows. If you’ve been using Aspire for years, your Transactions tab may have thousands of rows.

Fixes:

  • Archive old data: copy transactions older than 12–18 months to a separate “archive” spreadsheet, then clear those rows in your active sheet
  • Avoid unnecessary blank rows — don’t add hundreds of extra rows “just in case”
  • Close other Google Sheets tabs in your browser to free memory

Too many browser extensions

Ad blockers, Grammarly, and other extensions that scan page content can slow Sheets significantly.

Fix: Try opening your Aspire spreadsheet in an incognito/private window (which disables extensions). If it’s faster, an extension is the culprit.

Complex conditional formatting

Aspire uses conditional formatting for visual indicators. If you’ve added custom formatting rules, they can compound and slow things down.

Fix: Go to Format → Conditional formatting and review the rules. Remove any custom rules you added that aren’t essential.

Formula errors

#REF! errors

This means a formula references a cell that no longer exists — usually caused by deleting rows.

Fix:

  1. Check File → Version History for a version before the deletion
  2. If recent enough, Ctrl+Z may undo it
  3. If you can’t restore, compare the broken cell to the same cell in a fresh Aspire spreadsheet and copy the formula over

#N/A or #VALUE! errors

Usually caused by:

  • A category name in a transaction that no longer exists in the Configuration tab
  • A date or amount entered in the wrong format
  • Text in a cell that expects a number

Fix: Check the cells involved. Make sure amounts are numbers (not text), dates are valid, and all categories/accounts match what’s on the Configuration tab.

Circular dependency warnings

Google Sheets will warn you if a formula references itself. This shouldn’t happen in a clean Aspire spreadsheet.

Fix: This likely means a formula was accidentally edited. Compare the cell to a fresh spreadsheet copy and restore the original formula.

Formatting issues

Conditional formatting disappeared

If colors, indicators, or the pie charts on the Dashboard have stopped working:

  • Check if you accidentally cleared formatting (Edit → Undo)
  • Verify conditional formatting rules still exist (Format → Conditional formatting)
  • In extreme cases, start from a fresh spreadsheet and migrate your data

If the Category or Account dropdown in the Transactions tab is missing entries:

  • Verify the category/account exists on the Configuration tab
  • Check that it’s not in the Hidden Categories or Hidden Accounts section
  • The dropdown references a specific range — if rows were inserted/deleted, this range may be off

When to start fresh

If your spreadsheet has multiple formula errors, widespread formatting damage, or has become unreliable:

  1. Copy a fresh Aspire spreadsheet from the website
  2. Set up your current accounts and categories on the Configuration tab
  3. Enter starting balances using today’s actual bank balances
  4. Start logging transactions going forward

You’ll lose historical data, but you’ll have a clean, functional budget. Consider keeping the old spreadsheet as a reference for past reports.

Prevention

  • Never insert or delete rows
  • Never cut-and-paste — copy-and-paste or retype
  • Don’t edit cells you didn’t originally fill in — if it has a formula, leave it alone
  • Use “Highlight all editable fields and tables” on the Configuration tab to see what’s safe to touch
  • Back up monthly — File → Make a copy creates a snapshot you can restore from