Linked Cells not updating in report
I have created a dashboard to see the daily job status. One of the functions is to see how many jobs are open on Today's task list. This is based on countifs on the date of the task list.
The formula's are sometimes working, sometimes not. When we make an update on the tasklist, the report does not show the latest updated data, but the figures go back to the nrs from the day before.
Is there a delay in updating? The tricker seems to be that when a change is made, instead of showing the updated data, is shows old data. Anyone having similar issues, and more important, any idea how to solve this?