Update links

[Brisbane Rob]

We run a speadsheet which has to update over 7,000 links over a very
slow network. Is there any way of showing what percentage of the links
have been updated as the users wait (up to two minutes), and can it be
triggered from the "Update Links?" button?

Thanks in advance for any ideas.

 

[Thiem]

Private Sub CommandButton1_Click()
Application.Calculate
End Sub


Cgreate a command button ( Update link and this is the VBA code) firs
part of your question, still working on it

 

[Brisbane Rob]

Thanks - first part works great