How can I disable linking?

's Computer Specifications

I have tow workbooks that reference each other in hundreds of formulas and.
When I open one of the workbooks it starts linking the formulas with the
other workbook. This is really time consuming and takes like 10 min to open.
Can I disable link from code? In case it is imposible from code can I disable
this feature from options?

's Computer Specifications

The only way I know is to open the workbook from a VBA sub with
Workbooks.Open Filename:=wbname, UpdateLinks:=0

Regards,
Stefi

â€žVasil Ivanovâ€ ezt Ã*rta:

> I have tow workbooks that reference each other in hundreds of formulas and.
> When I open one of the workbooks it starts linking the formulas with the
> other workbook. This is really time consuming and takes like 10 min to open.
> Can I disable link from code? In case it is imposible from code can I disable
> this feature from options?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Object linking/Worsksheet linking/etc...	MikeH	Microsoft Excel Misc	0	15th Jun 2009 05:26 PM
An error msg in Excel 2007 regarding Linking but no linking in fil	Jugglertwo	Microsoft Excel Misc	0	12th Sep 2008 02:08 AM
Skin pocket pc, disable hardware buttons, disable start button	Tizio Incognito	Microsoft Dot NET Compact Framework	1	3rd Feb 2005 09:13 AM
Linking error in VC++ 6 while linking with a library developed in VC++ 7.	=?Utf-8?B?bmdudXNlcg==?=	Microsoft VC .NET	0	20th Feb 2004 07:11 PM
A Linking Error in VC++.net when linking to a WinCE.net dll	Kenric Li	Microsoft VC .NET	0	5th Nov 2003 02:25 PM