| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I disable linking?
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Object linking/Worsksheet linking/etc... | Excel Discussion (Misc queries) | |||
| Disable # | Excel Discussion (Misc queries) | |||
| An error msg in Excel 2007 regarding Linking but no linking in fil | Excel Discussion (Misc queries) | |||
| Disable the name box | Excel Programming | |||
| Disable ALT KEY | Excel Programming | |||
Hybrid Mode
