Dashboard and Sheet Not Updating Cell Referencing
I have a sheet with multiple countif formula referencing data from multiple sheets.
From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions based on it.
However, when I log back into my for some reason I see the totals in the dashboard reflect old data, and when I go into the sheet I see the totals there have reverted back to a previous (and incorrect) set of totals. Within 5 seconds it switches to the correct totals.
Currently, the only way to ensure people have the correct data is to log into the sheet regularly which is not feasible.
Help Article Resources
Check out the Formula Handbook template!