Another way (if using later versions of Excel) is to open the Edit Link
feature and choose which links you want to break. Be careful as there is no
going back from this. Can see how to do it on
http://www.auditexcel.co.za/othertools.html under External Links

"freekrill" wrote:


Hi,

I have a file which contains links to other workbooks. When I open it,
I get the message, "Do you wish to update links?"

My answer will always be "no".

Is there any way of stopping the message form appearing? (apart from
opening the file by a macro in a different file and setting
updatelinks: = 0)

Thanks for any help

free


--
freekrill
------------------------------------------------------------------------
freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561
View this thread: http://www.excelforum.com/showthread...hreadid=390824