Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Startup Prompt to update Links
Hello,
Excel 10 SP3, WIN XP Prof. 5.1 SP1 When I go to "Edit" = "Links" = "Startup Pompt" I can select "Don't display the alert and update links". But the alert is always displayed when I start a file with such a configuration. Does anyone know, what' s the use of this option? Regards Werner |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Startup Prompt to update Links
Werner Rohrmoser wrote:
When I go to "Edit" = "Links" = "Startup Pompt" I can select "Don't display the alert and update links". But the alert is always displayed when I start a file with such a configuration. I think that option is broken. If you are able to have macros within the file, I suggest you set it to Don't display the alert and don't update links. Then have the Workbook_Open macro update the links. In ThisWorkbook module Private Sub Workbook_Open() Dim vLinkSources Dim iLinkSource As Integer vLinkSources = ThisWorkbook.LinkSources(xlExcelLinks) If Not IsEmpty(vLinkSources) Then For iLinkSource = LBound(vLinkSources) To UBound(vLinkSources) ThisWorkbook.UpdateLink vLinkSources(iLinkSource), xlExcelLinks Next End If End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
Startup Prompt to update Links
Bill, thank you for the code, I'm going to use it in my files, in which I like to have always an update of the links. Regards Werner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Startup prompt - Update links | Excel Discussion (Misc queries) | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |