Hello,

I am trying to get my workbook to open without updating links and
without even asking to update links. I can get it to not ask me the
question but it still goes ahead and updates the links and it takes
even longer than if it had asked me the question and i had said yes.

this is my code in "This WorkBook"

Private Sub Workbook_Open()
Application.AskToUpdateLinks = False
UpdateRemoteReferences = False
End Sub

Does anyone know what I'm doing wrong and a way to solve this.

Many thanks for any replies

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=398979