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

What version of Excel do you have?

--
Jim
"johncassell" <johncassell.1ubeeb_1124964321.8094@excelforum-nospam.com>
wrote in message
news:johncassell.1ubeeb_1124964321.8094@excelforum-nospam.com...
|
| 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
|

Microsoft Excel 2000

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" <johncassell.1ubeeb_1124964321.8094@excelforum-nospam.com>
wrote in message
news:johncassell.1ubeeb_1124964321.8094@excelforum-nospam.com...
>
> 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
>

ok thanks for that Tom.