Troubleshooting Formula Issues — When Formulas Don't Recalculate
Fix formula recalculation issues in Unsheet: #VALUE errors, missing formulas, cross-sheet references, and unsupported functions. Quick solutions.
#VALUE! or #REF! Errors
If a cell shows #VALUE! or #REF!:
- The formula may reference cells outside the loaded data range
- A cross-sheet reference (e.g.,
=Sheet2!A1) can't be resolved in the single-sheet engine - The function may expect a different data type (text vs. number)
Fix: Ensure all referenced cells are within the main data sheet. Move lookup data into the primary sheet if possible.
Formulas Not Detected
If cells show static values instead of live formulas:
- The original file may have been saved with "Paste Values" instead of formulas
- For CSV files, formulas are not preserved (CSV is values-only)
Fix: Upload the original .xlsx file with formulas intact, or import from Google Sheets where formulas are always preserved.
Unsupported Functions
If a formula uses a function not supported by HyperFormula (like GETPIVOTDATA or dynamic arrays), the cell will show an error.
Fix: Replace unsupported functions with supported alternatives. Check the Supported Formulas Reference for the complete list.
Found this useful?
Share it with your team or network.
Frequently Asked Questions
Why are my formulas showing errors?
Related Guides
Live Formula Recalculation — How Unsheet Keeps Your Data Alive
Unsheet uses HyperFormula to evaluate 400+ Excel functions in real-time. Edit any value and watch totals, charts, and metrics update instantly.
Supported Excel Formulas in Unsheet — Complete Function Reference
Full list of 400+ Excel functions supported by Unsheet's HyperFormula engine. SUM, IF, VLOOKUP, INDEX/MATCH, and more — all recalculate live.
Ready to kill your spreadsheets?
Upload your first file and see the magic in under 30 seconds.
Get Started Free →