How to re-link an Excel spreadsheet.

[elkinm]

I have external program links going into excel. The problem is that if the linked program is closed or looses its connection the links stop updating.

If I restart the spreadsheet and update the workbook everything works fine.

I would like to know how can I update the workbook without restarting the spreadsheet, whether through a Macro button or directly through Excel.

Thanks

 

[elkinm]

This is the closest thing I found that may do what I need, but I don't understand it or how it needs to implemented.

Can it update existing link like restarting the spreadsheet or does it try to regenerate links?

Thanks

 

[elkinm]

I think that I can use something like ActiveWorkbook.UpdateLinks=xlUpdateLinksAlways to start links.
and use ActiveWorkbook.UpdateLinks=xlUpdateLinksNever to stop links.

but so far it is not working like I want it as does not take effect like the main Update workbook button. If I click the don't update button initially, Update Links does not work. If I hit update, then Update never does not stop the links.

Should this work?

anybody have any details on how these commands are supposed to work and maybe a full listing of Workbook. commands.

thanks
elkinm