Summary Sheets Not Updating

Hello. We have several summary sheets that feed reports and dashboard material. All was great until about a month ago when we noticed the summary sheets that contain formulas that reference other active sheets are not updating until you open them. As I mentioned, these feed into reports and dashboard graphs, so when nothing is updated, people are upset and I am left to open each sheet where I can see it update then.

Has anyone experienced this before? Does anyone have a solution?

Best Answer