How about just recording a macro when you do it manually.

Edit|Links|update values



damiand_1982 wrote:

Hi all,

I know that I can manually request update links on my worksheet but was
wondering whether anyone can provide me with the script for doing this.

I would like to include the updating of links in a macro I've already
created.

Any helps appreciated!

Cheers
Damian

--
damiand_1982
------------------------------------------------------------------------
damiand_1982's Profile: http://www.excelforum.com/member.php...o&userid=37461
View this thread: http://www.excelforum.com/showthread...hreadid=571647

--

Dave Peterson