#1   Report Post  
Old March 31st 06, 08:33 PM posted to microsoft.public.excel.misc
Brisbane Rob
 
Posts: n/a
Default Updating links


We have a summary spreadsheet with hundreds of links which is emailed to
a number of users. The automatic links update, and the prompt, have been
disabled because of problems caused when remote users attempted to do
the update.

Other than enable the links auto update and then disable it before
mailing the spreadsheet, is there another way of updating other than a
manual, one-by-one approach? A macro, maybe?

Secondly, is it possible to get an unopened sheet to update links
automatically when you open another one?

Thanks 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=528682


  #2   Report Post  
Old April 1st 06, 10:35 AM posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Updating links

Hi Brisbane Rob

Why not covert the links to values in the sheet you send
I have a option in my Add-in
http://www.rondebruin.nl/mail/add-in.htm

Secondly, is it possible to get an unopened sheet to update links
automatically when you open another one?

As far as I know No


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Brisbane Rob" wrote in message
news:[email protected] m-nospam.com...

We have a summary spreadsheet with hundreds of links which is emailed to
a number of users. The automatic links update, and the prompt, have been
disabled because of problems caused when remote users attempted to do
the update.

Other than enable the links auto update and then disable it before
mailing the spreadsheet, is there another way of updating other than a
manual, one-by-one approach? A macro, maybe?

Secondly, is it possible to get an unopened sheet to update links
automatically when you open another one?

Thanks 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=528682



  #3   Report Post  
Old April 1st 06, 09:54 PM posted to microsoft.public.excel.misc
Brisbane Rob
 
Posts: n/a
Default Updating links


Thanbks - that seems to answer one of my problems.

Still trying to figure out how to update the links in a closed
workbook...


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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating links to closed workbooks goofy11 Excel Discussion (Misc queries) 0 March 23rd 06 05:28 PM
External Links not updating Lou Di Pietro Excel Discussion (Misc queries) 0 September 15th 05 09:48 AM
?? Links Not Updating ?? djm023 Excel Discussion (Misc queries) 3 September 7th 05 02:10 PM
Links updating? Kimmerz321 Excel Discussion (Misc queries) 3 September 1st 05 01:31 PM
Updating Automatic links doesn't work with arrays Mats Samson Excel Discussion (Misc queries) 0 December 18th 04 04:17 PM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017