I have 33 unprotected workbooks on the network(schedules) which about 150
people can access which is linked to workbooks (date) that only 10 people can
access which is then linked to a protected workbook (projection) that 4000 +
people can access.
When data in (schedules) are changed, is there a way to automatically update
(date) without having to open it so (projection) will automatically update
when any user opens the file