Refresh/recalculate sheet automatically

Options

Hi. I have date based functions in my sheets. These are volatile and respond to the current date and time.

I've found that sheets need to be opened and saved before the data is recalculated for these functions. This is a problem. I need the data to be accurate.

I suspect I can add a column which refreshes hourly and inserts the date and time of the refresh and this will probably trigger a save and recalculation - however this seems like it should be unnecessary.

Before I try this out, is there a way of scheduling a refresh for all sheets in a workspace?

thanks

Ed

Best Answers

Answers