Updating Links on Open
 

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

Updating Links on Open
 

What version of Excel do you have?

--
Jim
"johncassell"
wrote in message
...
|
| 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
|

Updating Links on Open
 

Microsoft Excel 200

--
johncassel
-----------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...fo&userid=2501
View this thread: http://www.excelforum.com/showthread.php?threadid=39897

Updating Links on Open
 

The updating of links occurs before any code runs - so your code is useless.

In xl2002 and later, you have options to control this in Edit=Links.

In earlier versions, there is no easy solution. You can use two
workbooks - open a dummy workbook which has code to open the original
workbook without updating links (an argument in the open method) and then
close itself (the dummy workbook).

--
Regards,
Tom Ogilvy


"johncassell"
wrote in message
...

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

Updating Links on Open
 

ok thanks for that Tom.


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