UpdateLinks:= 0, links still get updated.

[Richard1482]

Hi,

Within one worksheet and I want to add a button to open source file for some formulas used within the workbook, However I don't want to update values when file is opened (mainly because it creates delay about 10 seconds on my machine and it will be used even on slower ones).

Code:
Workbooks.Open FileName:= _
"P:\_ACCOUNTING\Invoices\Invoice 3.1.xlsx", WriteResPassword:="xxxxxx", UpdateLinks:=0, Password:="xxxxxxxxx"

Even with this parameter it refreshes values, and I was not able to find online any help, therefore creating this post

Thank you very much!

Richard

 

[JRidge]

Something like:

[COLOR=#000080][FONT=Courier New]UpdateLinks:=xlUpdateLinksNever[/FONT][/COLOR]

If you never want to update links

or if you want to always update but not be asked:

[COLOR=#000080][FONT=Courier New]UpdateLinks:=xlUpdateLinksAlways[/FONT][/COLOR]

Of course i do not know what Version of Excel you are using.

 

[Richard1482]

Thank you for reply JRidge.

Unfortunately it does not work. I might specified it a bit inaccurate.
There is nothing to update in file which is being opened, but it updates links(values in formulas) in main workbook with macro.. I'm not sure if it makes any difference, just to make sure in case it does.

Setting manual calculation won't help and I could not think of anything else.