Manual Refresh of Links
 

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

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

"Carl Bowman" wrote:

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