Financial Performance Dashboard #REF error on loading
Some users with large amounts of transactions (>50,000) are affected by a Google Sheets related bug, which prevents certain sheets adding enough rows to contain the data automatically. The result of this is a dashboard that does not contain any transaction data, but still shows Balances for non-transaction related fields such as Cash On Hand.
Identifying And Resolving The Issue
To see if you are affected, follow these steps.
- Open the sheet with the suffix
- Hover your mouse over cell A4 - it should contain a
#REFerror with a message indicating that the “Result was not expanded automatically”. Note the number of rows required to be inserted
- Scroll to the bottom of the sheet, until you see a footer that allows you to add rows. Use this to add the number of rows recommended in the error message
- Wait for the sheet to recalculate - this can take 20-30 seconds as formulas refresh. Once transactions begin to populate in the sheet, the
Dashboardshould work as expected