ExcelBanter - How can I disable linking?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How can I disable linking? (https://www.excelbanter.com/excel-programming/376097-how-can-i-disable-linking.html)

Vasil Ivanov

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?

Stefi

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?

All times are GMT +1. The time now is 09:59 AM.