Share via

Excel for Mac External Data Connections Have Been Disabled

Anonymous
2018-12-04T16:24:08+00:00

I am getting this unwanted security warning. How do I stop it?

Excel for Mac 16.20 (181202) under Mojave 10.14.1. Everything is current

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

16 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-12-15T00:31:56+00:00

    I already told you that this suggestion did not work when I tried it. Frankly, this entire exchange has been a waste of time.

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-12-15T10:54:31+00:00

    Hi Danssmith,

    Sorry for the inconvenience it brings to you.

    I have tested with many previous versions and even in version 16.14, the warning is still there.

    I need to confirm the version you mentioned which doesn't have the warning.

    Best Regards,

    Gloria

    0 comments
  3. Anonymous
    2018-12-15T16:10:10+00:00

    This reply makes no sense. The problem is that the pivot table remains connected to the original file even when I copy both the pivot table and the source page to the new file. There is no problem with the warning.

    2 people found this answer helpful.
    0 comments
  4. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-12-15T16:35:38+00:00

    Hi Dan

    Does this information from Excel help address the issue? Specifically, do you see Edit Links on the Data tab of the Ribbon?

    Fix broken links to data

    0 comments
  5. Anonymous
    2018-12-15T17:01:22+00:00

    The issue is not a broken link. The issue (AGAIN!) is that I have copied a pivot table and its source worksheet over to a new file but the pivot table remains linked to the original file. Edit links is grayed out.

    6 people found this answer helpful.
    0 comments