When is data updated?

Your data is updated when the cache expires or when you choose to update it (for all the formulas in the selected cells, or for the entire spreadsheet) either with a manual update or through a trigger to automate it.

Check out our article about how to control when the data updates.