View Single Post
  #1   Report Post  
Old July 29th 05, 04:05 AM
sir Lancelot
 
Posts: n/a
Default automatically update links without opening file

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