FAQ
Issue: Data Loss Due to Formula Reload
Problem
Google Sheets automatically reloads all formulas every few hours. This includes formulas and can lead to unexpected costs and result changes.
Important Note: Sorting, filtering, moving columns or rows will reload ALL formulas and generate unexpected costs.
Solution (Workaround)
Replace formulas with values before moving things around or when you finish your work.
Steps to Replace Formulas with Values
Select the cells containing the formulas you want to replace.
Copy the selected cells (Ctrl+C or Cmd+C).
Right-click on the selected cells and choose "Paste special" > "Values only".
By following these steps, you can prevent Google Sheets from reloading formulas and incurring unexpected costs.
Last updated