Update links
 

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.


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=488134

Update links
 

Private Sub CommandButton1_Click()
Application.Calculate
End Sub


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


T


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=488134

Update links
 

Thanks - first part works great.


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=488134