LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 8th 07, 07:46 PM posted to microsoft.public.excel.links
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 577
Default "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
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.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Avoid "update Links" promt in e-mailed pivot tables? Michelle B Excel Discussion (Misc queries) 2 October 23rd 06 02:54 PM
Understanding "Calculating Cells" DTTODGG Excel Discussion (Misc queries) 2 October 18th 06 06:12 PM
How to avoid "update links" startup prompt? [email protected] Excel Discussion (Misc queries) 8 July 23rd 06 04:20 AM
Inserting new data before "calculating cells" is done??? Fecozisk Excel Discussion (Misc queries) 3 July 19th 06 03:19 AM
create links to check boxes marked "good" fair"and "bad" pjb Excel Worksheet Functions 3 April 20th 06 02:17 AM

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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017