Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
When I open a file with links to another file, a security warning shows in
the message bar showing that automatic update of links has been disabled. When I go to the Trust Centre it shows that Prompt User on Automatic Update of Links is selected. Microsoft help seems to imply that if I dont want to update, I should get a button Dont Update. However this button does not appear. Nor does an update button. When I open the file I want to be able to choose whether to update or not. What is the process to set this up and then how do I give the two instructions, Update or Dont Update? |
#2
![]() |
|||
|
|||
![]()
It sounds like you are having trouble with the automatic updates of links between files in Excel 2007. Here's how you can set up the process to choose whether to update or not:
Now, when you open the file with links to another file, you should see a security warning in the message bar. Click on the warning to see your options. You should see a button that says "Enable Content". Click on this button to update the links. If you don't want to update the links, simply click on the X in the top right corner of the warning to close it.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Excel 2007 makes the control of link updating harder, in my opinion;
certainly confusing! As far as I can tell, the old method of controlling the workbook-specific startup dialog has been replaced by an Excel-wide set of trust center settings. The result is as you have seen - in order to enable the links the user has to notice the bar that appears below the ribbon and click the Options button and then Enable this content. I am still trying to clarify with Microsoft exactly how they intended the different settings in Edit Links and in the Trust Center and in Excel Options to interact. It seems to me to be a bit of a mess. ---- Meanwhile, one option would be to have the users load a small workbook that does not contain links and have it give the user the choice of whether or not to update the links; it would then go on to open the real workbook (using the UpdateLinks argument of Workbooks.Open to give the required result); it would then close itself. --- The small workbook would contain a macro in a standard module, something like this: Sub Auto_Open() Application.OnTime Now, "Continue_Open" ' let Excel opening finish End Sub Sub Continue_Open() ' runs after the workbook is fully open Dim iUpdate As Integer If MsgBox("Shall I update the links?", vbYesNo) = vbYes Then iUpdate = 3 Else iUpdate = 0 End If ' change the file name in the next line... Workbooks.Open ThisWorkbook.Path & "\Real.xls", UpdateLinks:=iUpdate ThisWorkbook.Close End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#4
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Thank you Bill. If you are in discussion with Microsoft it might be worth
pointing out the the MS Help refers to a Don't Update button, which doesn't appear to exist. "Bill Manville" wrote: Excel 2007 makes the control of link updating harder, in my opinion; certainly confusing! As far as I can tell, the old method of controlling the workbook-specific startup dialog has been replaced by an Excel-wide set of trust center settings. The result is as you have seen - in order to enable the links the user has to notice the bar that appears below the ribbon and click the Options button and then Enable this content. I am still trying to clarify with Microsoft exactly how they intended the different settings in Edit Links and in the Trust Center and in Excel Options to interact. It seems to me to be a bit of a mess. ---- Meanwhile, one option would be to have the users load a small workbook that does not contain links and have it give the user the choice of whether or not to update the links; it would then go on to open the real workbook (using the UpdateLinks argument of Workbooks.Open to give the required result); it would then close itself. --- The small workbook would contain a macro in a standard module, something like this: Sub Auto_Open() Application.OnTime Now, "Continue_Open" ' let Excel opening finish End Sub Sub Continue_Open() ' runs after the workbook is fully open Dim iUpdate As Integer If MsgBox("Shall I update the links?", vbYesNo) = vbYes Then iUpdate = 3 Else iUpdate = 0 End If ' change the file name in the next line... Workbooks.Open ThisWorkbook.Path & "\Real.xls", UpdateLinks:=iUpdate ThisWorkbook.Close End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#5
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
This post is a little stale but, it best describes the issues I have been
having and it sounds like you were looking into it further. I too have several workbooks that are linked and the users of these workbooks would rather have a choice on wheather to update links or not. The major problem is as stated, that the prompts to appear as the documentation tells you they should. This is my scenario: 1. Users have several workbooks that have links to others. 2. Users do not want the links to always automatically update. 3. Users would like these source locations to also be in trusted sites for their macros. This is where we run into the issue. When the workbook is in the trusted sites, it will not follow the rules to prompt for updating links (like Excel 2003 did). Even with the settings of "Ask to update automatic links" in the options and the Startup Prompt set to "Let users choose to display the alert or not", the links will update regardless. If you set the startup to "Don't display the alert and don't update automatic links" then the links do not update but, they don't prompt either. Did you get any further with Microsoft on working with linked workbooks? To me it still seems there is something broken as it does not behave how the Excel documentation says it should. Any input would be great. Thanks! "Bill Manville" wrote: Excel 2007 makes the control of link updating harder, in my opinion; certainly confusing! As far as I can tell, the old method of controlling the workbook-specific startup dialog has been replaced by an Excel-wide set of trust center settings. The result is as you have seen - in order to enable the links the user has to notice the bar that appears below the ribbon and click the Options button and then Enable this content. I am still trying to clarify with Microsoft exactly how they intended the different settings in Edit Links and in the Trust Center and in Excel Options to interact. It seems to me to be a bit of a mess. ---- Meanwhile, one option would be to have the users load a small workbook that does not contain links and have it give the user the choice of whether or not to update the links; it would then go on to open the real workbook (using the UpdateLinks argument of Workbooks.Open to give the required result); it would then close itself. --- The small workbook would contain a macro in a standard module, something like this: Sub Auto_Open() Application.OnTime Now, "Continue_Open" ' let Excel opening finish End Sub Sub Continue_Open() ' runs after the workbook is fully open Dim iUpdate As Integer If MsgBox("Shall I update the links?", vbYesNo) = vbYes Then iUpdate = 3 Else iUpdate = 0 End If ' change the file name in the next line... Workbooks.Open ThisWorkbook.Path & "\Real.xls", UpdateLinks:=iUpdate ThisWorkbook.Close End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#6
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Paul,
You and I are probably looking for the same answer in the same spots. I've seen your post on another forum like this as well. I have scoured the internet trying to find the answer to this problem. It appears no one has an answer. I really think it's a bug that hopefully Microsoft will address in SP2 of Office 2007. No matter what, it never prompts, just like you say, unless the workbook is in an untrusted location. Then you can choose not to enable content, however then you disable macros as well, which is not ideal. "Paul Wetter" wrote: This post is a little stale but, it best describes the issues I have been having and it sounds like you were looking into it further. I too have several workbooks that are linked and the users of these workbooks would rather have a choice on wheather to update links or not. The major problem is as stated, that the prompts to appear as the documentation tells you they should. This is my scenario: 1. Users have several workbooks that have links to others. 2. Users do not want the links to always automatically update. 3. Users would like these source locations to also be in trusted sites for their macros. This is where we run into the issue. When the workbook is in the trusted sites, it will not follow the rules to prompt for updating links (like Excel 2003 did). Even with the settings of "Ask to update automatic links" in the options and the Startup Prompt set to "Let users choose to display the alert or not", the links will update regardless. If you set the startup to "Don't display the alert and don't update automatic links" then the links do not update but, they don't prompt either. Did you get any further with Microsoft on working with linked workbooks? To me it still seems there is something broken as it does not behave how the Excel documentation says it should. Any input would be great. Thanks! "Bill Manville" wrote: Excel 2007 makes the control of link updating harder, in my opinion; certainly confusing! As far as I can tell, the old method of controlling the workbook-specific startup dialog has been replaced by an Excel-wide set of trust center settings. The result is as you have seen - in order to enable the links the user has to notice the bar that appears below the ribbon and click the Options button and then Enable this content. I am still trying to clarify with Microsoft exactly how they intended the different settings in Edit Links and in the Trust Center and in Excel Options to interact. It seems to me to be a bit of a mess. ---- Meanwhile, one option would be to have the users load a small workbook that does not contain links and have it give the user the choice of whether or not to update the links; it would then go on to open the real workbook (using the UpdateLinks argument of Workbooks.Open to give the required result); it would then close itself. --- The small workbook would contain a macro in a standard module, something like this: Sub Auto_Open() Application.OnTime Now, "Continue_Open" ' let Excel opening finish End Sub Sub Continue_Open() ' runs after the workbook is fully open Dim iUpdate As Integer If MsgBox("Shall I update the links?", vbYesNo) = vbYes Then iUpdate = 3 Else iUpdate = 0 End If ' change the file name in the next line... Workbooks.Open ThisWorkbook.Path & "\Real.xls", UpdateLinks:=iUpdate ThisWorkbook.Close End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#7
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Anyone find an answer to this? Office 2007 SP2 did not solve the issue for me.
|
#8
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Depends on what the issue is. What is the problem you're having?
-- Cheers macropod [Microsoft MVP - Word] "GuestionGuy" wrote in message ... Anyone find an answer to this? Office 2007 SP2 did not solve the issue for me. |
#9
![]() |
|||
|
|||
![]() Quote:
I need some help on this too, as I use Excel 2007 to calculate the sales prices. For my personnel to always have updated prices, the spreadsheet needs to access my master price sheet (which is password protected). Please help. rioj Last edited by rioj : December 9th 10 at 12:08 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
links between 2007 version files and 97-2003 version files | Links and Linking in Excel | |||
Excel 2007 Destroys Links In Excel 2003 Files? | Links and Linking in Excel | |||
How can I create a soccer chart with automatic updates in Excel | Charts and Charting in Excel | |||
strange problem with links updates in excel | Excel Discussion (Misc queries) | |||
Excel Links Updates in 2003 | Excel Worksheet Functions |