+ Reply to Thread
Results 1 to 3 of 3

How to stop "Security Warning Data Connections have been disabled" MAC OS Excel 2016

  1. #1
    Forum Contributor
    Join Date
    09-11-2014
    Location
    Eugene, Oregon
    MS-Off Ver
    MS EXCEL 2010
    Posts
    210

    How to stop "Security Warning Data Connections have been disabled" MAC OS Excel 2016

    I have the unfortunate pleasure of working in Excel on a MAC. I have created a couple data connections to an Access database and every time I open the Excel spreadsheet the security warning is there saying the data connections have been disabled. I do not want this showing up every time the file is opened, is there a way to always enable this upon opening the file? I have scoured the internet with no luck and the questions has been asked before with the usual " Go to your trust center settings" Excel for MAC's does not have a trust center so that doesn't work.

  2. #2
    Forum Contributor
    Join Date
    06-12-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    167

    Re: How to stop "Security Warning Data Connections have been disabled" MAC OS Excel 2016

    No promises this will work but place this in the thisworkbook section of the Microsoft office excel folder in your project. I am unfamiliar with the error but it might work, no promises.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-11-2014
    Location
    Eugene, Oregon
    MS-Off Ver
    MS EXCEL 2010
    Posts
    210

    Re: How to stop "Security Warning Data Connections have been disabled" MAC OS Excel 2016

    Unfortunately that didn't work, however When I was testing the database connection I had the DB located on my desktop but once I moved it to our central server the issue went away so I have to assume that it had something to do with file location but not 100% sure. Anyways thank you for the effort.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Date in Excel ("30/09/2016") copies incorrectly into Access ("30/05/1905")
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-30-2017, 05:19 AM
  2. Replies: 4
    Last Post: 06-01-2017, 11:45 PM
  3. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  4. Replies: 3
    Last Post: 02-23-2015, 12:33 AM
  5. [SOLVED] Excel 2007 "security alert - data connection" message every time?
    By michael.monaco in forum Excel General
    Replies: 2
    Last Post: 12-20-2012, 02:24 PM
  6. Excel 2007 and security Warning (macros disabled)
    By mhni in forum Excel General
    Replies: 1
    Last Post: 09-10-2009, 11:46 AM
  7. How to stop warning message in Excel "initialize ActiveX controls"
    By Sya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2006, 05:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1