Manual Refresh of Links

[Guest]

Is there a VB command that will refresh links even though the question "Do
you want to refresh links?" was answered "No" when the workbook was opened?
After making changes to many formulas I need the workbook to refresh the
links now but it is not doing it when I press F9.
Thanks

 

[Guest]

Carl,

I have posted a programmatic solution to http://Galimi.com/Examples/Links.xls

You can also click, Edit, Links, Update to update all the links in your
current workbook.

Regards,
http://HelpExcel.com