#1   Report Post  
Old June 6th 05, 10:33 PM
ynissel
 
Posts: n/a
Default update links

I have a few users that are annoyed that every time they open a specific file
I created with links and marcos - they have to click the message box to
update links. Is there a way that the links are updated automatically
without prompting ?
Thanks,
Yosef

  #2   Report Post  
Old June 6th 05, 11:15 PM
Dave Peterson
 
Posts: n/a
Default

Saved from a similar question:

You can toggle the setting (user by user, though) via:

Tools|Options|Edit Tab.
There's a checkmark for "ask to update automatic links"

But this means that you suppress the question--the links still get updated.

This setting is for the individual user--and affects all their workbooks.

If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)


ynissel wrote:

I have a few users that are annoyed that every time they open a specific file
I created with links and marcos - they have to click the message box to
update links. Is there a way that the links are updated automatically
without prompting ?
Thanks,
Yosef


--

Dave Peterson
  #3   Report Post  
Old June 7th 05, 02:40 PM
ynissel
 
Posts: n/a
Default

Thanks Dave - can this be done with an automatic marco to run as soon as you
open the file so I dont have to force them to open a different document ?

"Dave Peterson" wrote in message
...
Saved from a similar question:

You can toggle the setting (user by user, though) via:

Tools|Options|Edit Tab.
There's a checkmark for "ask to update automatic links"

But this means that you suppress the question--the links still get
updated.

This setting is for the individual user--and affects all their workbooks.

If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls",
UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)


ynissel wrote:

I have a few users that are annoyed that every time they open a specific
file
I created with links and marcos - they have to click the message box to
update links. Is there a way that the links are updated automatically
without prompting ?
Thanks,
Yosef


--

Dave Peterson



  #4   Report Post  
Old June 7th 05, 06:28 PM
Dave Peterson
 
Posts: n/a
Default

The link prompt appears before your code starts. So the code can't be in the
workbook with the links.



ynissel wrote:

Thanks Dave - can this be done with an automatic marco to run as soon as you
open the file so I dont have to force them to open a different document ?

"Dave Peterson" wrote in message
...
Saved from a similar question:

You can toggle the setting (user by user, though) via:

Tools|Options|Edit Tab.
There's a checkmark for "ask to update automatic links"

But this means that you suppress the question--the links still get
updated.

This setting is for the individual user--and affects all their workbooks.

If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls",
UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)


ynissel wrote:

I have a few users that are annoyed that every time they open a specific
file
I created with links and marcos - they have to click the message box to
update links. Is there a way that the links are updated automatically
without prompting ?
Thanks,
Yosef


--

Dave Peterson


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit Links: make update manual Chrissorr Excel Discussion (Misc queries) 5 May 11th 05 11:57 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM
Manually update links Emma Excel Worksheet Functions 0 February 22nd 05 01:23 PM
Update Automatic Links Not Working in 2003 cydkil Excel Discussion (Misc queries) 2 February 15th 05 03:35 PM
Update Individual Links mikxtr Excel Discussion (Misc queries) 3 January 21st 05 04:24 AM


All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017