View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default How can I disable linking?

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?