ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   "don't update" links & calculating cells (https://www.excelbanter.com/links-linking-excel/134077-dont-update-links-calculating-cells.html)

scott

"don't update" links & calculating cells
 
I have a workbook (A) that has links to and will open 3 other workbooks
(B,C,D)when opened. One of these 3 workbooks (B) has links to the other two
(C,D). I have the following startup macro.

Private Sub Workbook_Open()
Application.DisplayAlerts = False
Workbooks.Open Filename:= "C.xls", UpdateLinks:=False
Workbooks.Open Filename:= "D.xls", UpdateLinks:=False
Workbooks.Open Filename:= "B.xls", UpdateLinks:=False
Windows("A.xls").Activate
Application.DisplayAlerts = True
End Sub

Woorkbooks C & D open in about 5 seconds. The problem is that workbook B
takes about 60 seconds to open because it goes through "calculating cells".
Is there anyway to not have it go through its update? I have tried modifying
the registry by placing a DWORD - FullCalcOnLoadOldFile = 0 on the
Excel/Options section. That didnt work.



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

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