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-06T15:44:48+00:00

    OS is Mojave 10.14.1

    The problem does not happen with all local files. What I said is that the files with the problem are local.

    The files in question have no external links.

    I sent you a link to a sample file on OneDrive.

    I am not going to spend time messing with Safe Mode.

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-12-06T23:56:11+00:00

    Hi Danssmith,

    Thanks for your link in Private Message.

    When I try to access the link in browser, I get the following error message.

    It seems that there are some connections in the workbook, please click data tab then connections to see if there are some.

    In addition, please check the Private Message again and I have replied in it.

    Best Regards,

    Gloria

    0 comments
  3. Anonymous
    2018-12-07T00:17:11+00:00

    Here are the connections:

    I will try again to send you a OneDrive link, but OneDrive is not very reliable.

    4 people found this answer helpful.
    0 comments
  4. Anonymous
    2018-12-07T22:54:01+00:00

    Hi Danssmith,

    Thanks for your link in PM and I have checked the workbook.

    Please check in PM at your convenience since there is some private information.

    Best Regards,

    Gloria

    0 comments
  5. Anonymous
    2018-12-08T06:56:12+00:00

    Hi Danssmith,

    Thanks for your reply in Private Message.

    According to my test, when I copy the pivot table to another workbook, it will also copy the connection to the new one.

    You can paste as no format to avoid the connection if you don't need it.

    For this issue doesn't happen in previous version, we would like to suggest you leave a comment to Excel for Mac UserVoice to let the product team know your requirement.

    You can also click the smile face in the Excel client to provide a feedback, it will also be sent to the product team.

    Thanks for your understanding.

    Best Regards,

    Gloria

    0 comments