I have a workbook that is updated regularly through out the day. I want to build a quick dashboard that would allow an individual to access information off of that workbook. The dashboard has to be dynamic so that they can look at particular days as well as showing real time progress during the current day. The workbook that is being updated is stored on a share network drive so that multiple people can access it through out the day.
I have tried to use the indirect function to link the dashboard to the other workbook and It works just fine as long as that work book is open on the computer also using the dashboard. As soon as you shut down the workbook with the data the dashboard can no longer display any information and has multiple #REF! errors.
Is there a function that I can use instead of indirect to access information from a possible closed workbook on a different computer?
I am including some sample books for reference.
Bookmarks