Prevent update of links, when opening a workbook

[AdamParker]

SOLVED COMMENTS:
Protect worksheet, then run macro, then unprotect.. works fine.. Thanks!
-------------------------------------------------------------------------------------------------------


Hello,
I have a "launcher" workbook that contains a lot of formulas linked to other worksheets.

One of the workbooks that it is linked to requires some manipulation...

Every day this workbook is replaced with a fresh query, just a dump of some data. Everytime I run the macro that opens this workbook, the links in my launcher workbook turn to #REF because the sheets that the macro creates have not been created yet... even though in just a few seconds they will be available... (the macro just produces a bunch of pivot tables, these links point to these worksheets that the pivot tables reside on)

When I open the workbook I am using UpdateLinks:=False but it's not working...
Is there anyway that I can suppress the updating of these links so that I can run the macro that opens the file and processes it safely?

Any help would be appreciated,
Thanks

Adam

[realniceguy5000]

Hello,
I have a "launcher" workbook that contains a lot of formulas linked to other worksheets.

One of the workbooks that it is linked to requires some manipulation...

Every day this workbook is replaced with a fresh query, just a dump of some data. Everytime I run the macro that opens this workbook, the links in my launcher workbook turn to #REF because the sheets that the macro creates have not been created yet... even though in just a few seconds they will be available... (the macro just produces a bunch of pivot tables, these links point to these worksheets that the pivot tables reside on)

When I open the workbook I am using UpdateLinks:=False but it's not working...
Is there anyway that I can suppress the updating of these links so that I can run the macro that opens the file and processes it safely?

Any help would be appreciated,

Adam

Hi Adam,

Maybe you can try Updatelinks:=0
Like this

Set wbOpen = Workbooks.Open(Filename:=Mypath & excelfile, UpdateLinks:=0

Thanks, Mike

[AdamParker]

No luck...

The second that worksheet gets opened, all of the linked cells goto #REF... is there any way to freeze those cells, ie: prevent any updates? while I run the macro... or potentially I suppose I could modify them someway to make it not a formula, and then have them modified back... not really sure what's best... cell protection seems like a good idea, but haven't really researched it/tried it out yet, will let you know if this works...

thanks for your suggestion