ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Updating Links (https://www.excelbanter.com/excel-worksheet-functions/13468-updating-links.html)

Doug

Updating Links
 
I have a master workbook containing job (other workbooks) summary
information. When I open the master it asks to update links ... I answer yes
.... for some of the linked workbooks ... Excel presents the file name on the
screen waiting for me to highlight and click "OK" but for others it seems to
do its link without screen request.

Questions: (1) I am not sure if the subsidiary files information is being
updated, (2) how can I make this more automatic so that I do not have to
highlight any subsidiary workbooks?

Thank you


All times are GMT +1. The time now is 01:30 PM.

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