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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com