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

  1. Select the cells containing the formulas you want to replace.

  2. Copy the selected cells (Ctrl+C or Cmd+C).

  3. 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