ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   automatically update links without opening file (https://www.excelbanter.com/excel-worksheet-functions/37670-automatically-update-links-without-opening-file.html)

sir Lancelot July 29th 05 04:05 AM

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


All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com