Remove message when opening workbook.

Posted on 2011-10-26
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
    LVL 6

    Expert Comment

    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

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

    Accepted Solution

    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

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now