Fix common spreadsheet errors
If you see unexpected errors in your SheetsFinance spreadsheet, check the symptoms and fixes below. Most issues are resolved by adjusting sheet space, refreshing the add-on, or correcting how a template was copied.
#REF! or #SPILL! errors
Symptom: A SheetsFinance function returns #REF! with the message "Array result was not expanded because it would overwrite data in XX".
Cause: The function is trying to output an array that spans multiple rows and columns, but one or more cells in that range already contain data.
Fix: Clear the cells in the target range before entering the function. Make sure the area below and to the right of the formula is empty so the array can expand.
#NAME? errors when copying templates
Symptom: After copying a Google Sheets template, functions show #NAME? instead of data.
Cause: After copying a template, Google Sheets caches third-party extensions, so the add-on functions may not resolve immediately in the new copy.
Fix: Close the copied spreadsheet and return later so the cache clears and the template formulas resolve. Only open Extensions > SheetsFinance > Account when account connection or permissions are actually missing.
Missing assets in Symbol Search
Symptom: A ticker or asset you expect does not appear in Symbol Search.
Cause: A type or exchange filter is hiding it, the ticker is written differently in our data (for example with an exchange suffix), or we don't cover the asset yet.
Fix:
Remove any type or exchange filter, then search again.
Search by the company or fund name instead of the ticker. Symbol Search matches names as well as tickers.
Check that we cover that kind of asset in Supported instruments.
If it is still missing, search for it on the web Symbol Search and click Tell us under the empty results. It opens our contact form with your search filled in.
Performance slowdowns
Symptom: Spreadsheets with many SheetsFinance functions calculate slowly or appear to hang.
Cause: Each function makes a live data request. Large arrays, many symbols, or frequent refreshes can overwhelm the sheet and the API.
Fix:
Reduce the number of live formulas by converting static results to values where you do not need real-time updates.
Use metric chaining to return only the columns you need instead of
"all".Break large portfolios into separate spreadsheet files rather than separate sheets in one file.
Brokerage data delays
Symptom: Brokerage holdings, orders, or balances do not match what you see in your broker app.
Cause: Some brokerage providers enforce data delays (for example, up to 24 hours) before the data is available via third-party connections.
Fix: Check the supported broker list for the specific delay policy of your broker. This is a provider restriction, not a SheetsFinance issue. If the delay exceeds the documented range, verify that your account is fully connected and re-authenticate if necessary.
Brokerage connections are read-only. SheetsFinance cannot execute trades or modify positions in your brokerage account.