Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Update Individual Links | Excel Discussion (Misc queries) |