24 January 2017

Excel 2016: this workbook contains links to one or more external sources that could be unsafe

I get this message sometimes when opening a workbook. Generally I have copied a formula from another workbook instead of a value, but i always want to check before breaking things.

I used a Microsoft support article (ignored the Edge promo):

  1. Type CTRL+F (opens Find and Replace Window)
  2. Click [Options >>]
  3. Fill in these values
    1. Find What: \[
      1. the MS article uses [, but I got some false positives from that
    2. Within: Workbook
    3. Look in: Formulas
  4. Click [Find Next] to search
If after verification you want to get rid of the warning, use the advice you get by clicking the Help button in the box:
  1. On the Data tab, in the Connections group, click Edit Links
    Here you can also update and break the links, but you do not see in which cells they are used.
  2. Click [Startup Prompt...]
  3. Select the option that you want