Hi everyone, I have a scenario that worked well for 3 years, but in the past 6 months or so has become unreliable:
As part of a templated toolset, I have
- a couple of 'worksheets' (where users are visiting and making updates),
- a 'calc sheet' that's pulling information together from these worksheets via index formulas with cross-sheet references,
- and a report of the calc sheet that displays on a dashboard.
Lately, a change will be made on a worksheet, but that change won't be reflected on the dashboard until I interact with the calc sheet and its report. Once I open the calc sheet and refresh it (sometimes several times), and do the same on the report, the changes will finally update on the dashboard.
These are INDEX formulas that are not making use of the TODAY function (although the behavior seems similar to TODAY's known issue on un-visited sheets).
I have an automation recording today's date on every row of the calc sheets, every day, but that's not keeping the data "awake" the way I hoped it would.
There are about 2 dozen instances of this toolset in use right now, and I'm aware the issue is happening on 3 of them, but wouldn't be surpised if it's more widespread and just not being noticed yet by the users.
Aside from opening each of these calc sheets and reports every day… any other ideas for keeping their data current?
