Sometimes you might need to configure the cache lifetime of the calculated values to days, hours, or to be handled during the session. This really depends on how frequent your users update the data. Some of my users change the data weekly and some they want the data to be recalculated every time to view the workbook. Unfortunately cache lifetime is not set per workbook but instead on each Trusted Location.
To configure cache lifetime, follow these steps:
The default value is 300 seconds.
For example you can set it to:
You can also ask your users to use the Calculate Workbook to recalculate the workbook values on the spot.
My advice to you is when gathering requirements from stake holders make sure to understand how often they update their files. This way you can deliver good performance and on the same time make sure to setup the cache lifetime in a satisfying way.