+ Reply to Thread
Results 1 to 6 of 6

Data connections have been disabled

  1. #1
    Registered User
    Join Date
    08-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2011 For Mac
    Posts
    4

    Question Data connections have been disabled

    So I've seen people ask this question before, but I can't seem to find a solution...

    My workbook keeps saying "Security Warning. Data connections have been disabled." There are NO data connections in this workbook. I've even deleted every macro, deleted every worksheet (only leaving a blank new sheet left) and it still says that. The only way I was able to sort of fix it was by saving the .xslm as a .xls, but that corrupted two of the worksheets, which obviously is not a useful solution. Anybody?

    Working in Excel 2011 For Mac and OS 10.8.4

    Thanks!

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Data connections have been disabled

    The data connection is in Data, Connections, Connections.

    Go in there, and break the links.

  3. #3
    Registered User
    Join Date
    08-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2011 For Mac
    Posts
    4

    Re: Data connections have been disabled

    Hey daffodil - Excel for Mac does not have the same menu items as the PC counterpart; the closest thing is Data -> Get External Data, but there is no option there to manage connections/break links. I appreciate your quick response though!

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Data connections have been disabled

    As tempted as I am to go unearth my G3, I figure I'd suggest this first. Here we go!

    On the Edit menu, click Links.
    In the Source list, click the link you want to break.
    To select multiple linked objects, hold down CTRL and click each linked object.

    To select all links, press CTRL+A.

    Click Break Link.
    If the link used a defined name, the name is not automatically removed. You may want to delete the name as well.
    http://office.microsoft.com/en-us/ex...003065606.aspx
    Last edited by daffodil11; 08-23-2013 at 03:42 PM. Reason: Quote from source

  5. #5
    Registered User
    Join Date
    08-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2011 For Mac
    Posts
    4

    Re: Data connections have been disabled

    Thanks daffodil11 - couldn't find the answer there, but a user on another forum pointed me to here: http://answers.microsoft.com/en-us/m...0-f529b76a1e5d

    The answer, which is quite simple, is just to copy all the sheets into a new workbook and replace the references to the original workbook with "". Thank you for your help!

  6. #6
    Registered User
    Join Date
    01-10-2018
    Location
    Suffolk, England
    MS-Off Ver
    Excel for Mac 2011 v14.7.7
    Posts
    1

    Re: Data connections have been disabled

    Thanks for the Links info for a Mac

+ 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. Data Connections Problem
    By karagill in forum Excel General
    Replies: 5
    Last Post: 12-05-2012, 03:17 PM
  2. Deleting Data Connections
    By dssrun209 in forum Excel General
    Replies: 0
    Last Post: 06-20-2012, 05:00 PM
  3. Replies: 2
    Last Post: 05-24-2012, 08:43 AM
  4. Run Away Data Connections / Query?
    By mrIslic in forum Excel General
    Replies: 0
    Last Post: 10-04-2011, 10:18 AM
  5. Workbook & Data Connections
    By JBullseye in forum Excel General
    Replies: 2
    Last Post: 10-10-2008, 03:10 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