[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Remove message when opening workbook.

Posted on 2011-10-26
Medium Priority
Last Modified: 2012-05-12
I have a workbook that users open, when it is opened it has a message saying "This workbook contains links to other sources" "UPDATE" "DONT UPDATE".
I would like this message to not appear and for it to automatically choose "dont update"
Is this possible?
Question by:RobJanine
  • 2

Expert Comment

ID: 37035067
You may be able to, as long as you trust the source the links are feeding from.

You can find the option to turn this prompt off in the Trust Center.

2007:  Office button > Excel options > Trust Center > Trust Center Settings > External Content
2010:  File > Options > Trust Center > Trust Center Settings > External Content

You can select the "Disable" options for workbook links.  You may, or may not, need the data connections option.


Author Comment

ID: 37035080
That will not work as it has to run on my staff laptop's on site. Can it somehow chose "dont update" it self?

Accepted Solution

reitzen earned 2000 total points
ID: 37035193
No, it cannot choose this itself.

If you have access to the file, you might be able to prevent these prompts by blocking them in the Workbook_Open event.  However, if this file is generated from an outside source then this will not be an option.

If you do have access to this file, then again, you may have a prompt where the user will need to "Enable content" which will allow the macro code to run.  This prompt depends on the enable/disable option that is set in your Trust Center.
LVL 50
ID: 37419406
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question