Share via

Always enable External Data Connections

Anonymous
2018-03-01T22:38:51+00:00

I know how to always enable external Data Connections in Excel 2016 for PC but cannot seem to find anything on how to do it for MAC. Is it possible to always enable data connections without having to click that yellow bar that says enable content.

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

Answer accepted by question author

Vijay A. Verma 104.9K Reputation points Volunteer Moderator
2018-03-02T02:37:16+00:00

I don't think this is possible like Windows. Looked into all possible options.

Let's see if some other expert can come up with a way.

Was this answer helpful?

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-03-10T20:22:03+00:00

    E is correct. You can't disable that bar,

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-03-06T16:35:44+00:00

    Go to Developer Tab click "Addins" go to store and look for Stock Connector. See that will do what you need. Also, Check to see if you have this:

    __________

    Disclaimer:

    The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2018-03-06T16:23:58+00:00

    Thanks E for Excel. I kind of thought that would be the case.

    Was this answer helpful?

    0 comments