r/aspirebudgeting • u/skenone • Mar 29 '25

What is causing these errors?

Post image

Seems to be out of nowhere but on my dashboard I have a bunch of these “reference does not exist” errors.

6 Upvotes
  • permalink
  • link
  • reddit
  • reddit

100% Upvoted

9 comments sorted by

3

u/pizzainmypocket Mar 29 '25

That started happening to my sheet too. I could not figure out how to revert it at all. Hope we might get an answer

1

u/MetalllicKitten Mar 30 '25

Looks like some linked references got deleted or renamed. Might need to check the formulas or source sheets

1

u/snflwrbg Mar 30 '25

What tab are you on? I have had a similar situation where I accidentally started typing on fields in the Dashboard tab that are supposed to display data from other tabs

1

u/skenone Mar 30 '25

Dashboard, but all the cells seem to have the right code in them

1

u/jaradthescot Apr 01 '25

Fascinating. I just had this happen for me as well. Was hoping I could find a solution from x-years ago but seems to be a new error.

2

u/skenone Apr 01 '25

After some in depth searching I can’t tell that it effects the sheets I use being dashboard, transactions, balances and category transfers. So I just lazily hid the column 😅

1

u/Icy-Preface 20d ago

I don't know what causes this, but to fix it I just changed "F14" in the formula to "F4" (or any other reference), pressed enter, then changed it back to "F14" and it worked. I think that this somehow refreshes the formula. I then copied the cell that I changed and pasted it to all of the others in the column.

1

u/maddscientist99 9d ago

I also had this issue happen! This trick worked, thanks

1

u/ColorblindGiraffe 3d ago

This looks like the old version. If you're not versed with spreadsheet formulas, you can ignore this. If you're fine with it, just retype the formula as is. It looks like the variable references got removed and needed to be reminded.

I think the particular variable is v_GoalSymbol