Sheet Summary Not Updating Automatically

Options

I have a formula in my sheet summary that uses countif and today (). However the data doesn't automatically update unless I open the sheet and click on the sheet summary. Then I can see the data change in the sheet summary fields. Why do I have to go into the sheet and sheet summary for updates to take place? Why doesn't it automatically update?

Answers