Updatelinks

[John Brenner]

Hi All -

I need to supress the updatelinks question that appears when you open the
excel file. I am not using workbooks.open - I'm simply double-clicking on the
file. Is there a small piece of code that I can put in the Workbook (Open)
'module' so that the links are automatically updated (Updatelinks = 3)?

Thank you!

 

[Dave Peterson]

Nope.

By the time excel gets to your macro, the links have already been addressed.

You can toggle that setting via the user interface before you open the
workbook--If you need a macro, maybe you could have another workbook that
toggles the setting, then opens the real workbook.