Updating links in Excel

Posted on 2014-07-15
Last Modified: 2014-07-16
I have some workbooks that have some sheets linked to other workbooks. Upon opening one of those linked file Excel gives me their cryptic message:
update link messageI would like to change that to "Update Linked Worksheets" with yes/no options.
Is there a way to do this?
Question by:Frank Freese
    LVL 31

    Accepted Solution

    This is a standard dialogue box for which I don't believe there is a way to change.

    What is the problem with using this dialogue? Update = Yes, Don't Update = No. You also have the option to get help if required.

    Rob H

    Author Comment

    by:Frank Freese
    I was hoping to just simplify this for my users - nothing special. I'm not surprise that it is unlikely this message you be customized. I found nothing across the Internet to suggest it could, however, someone out here may have done something like I was asking.
    Thanks Rob

    Author Closing Comment

    by:Frank Freese
    good answer - not what I wanted to hear but it is what I needed to hear.
    thank you sir

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    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;…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    760 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

    10 Experts available now in Live!

    Get 1:1 Help Now