Microsoft Office products such as Excel and Word have safeguards added that are designed to protect your data from malicious harm. One of these protections is defaulted to not allow you to update your spreadsheets used to pull information from other programs without additional steps. You’ll know when this is the case when you see a message such as “Security Warning Data connections have been disabled at the top of the Excel spreadsheet alongside a button “Options” or “Enable Editing”. To enable the data connection temporarily so that you can continue with your work, simply click on the ”Options” or “Enable Editing” button and select “Enable this content” option.
![How To Allow Incoming Connections On Mac For Excel How To Allow Incoming Connections On Mac For Excel](/uploads/1/2/5/4/125409636/285270329.jpg)
If you feel that you only open safe data files and want to enable the content automatically, follow these steps MS Excel:. Activate Microsoft Excel, click on File on the top left. Choose Options, Trust Center, Trust Center Settings. On the left choose External Content, then “Enable all Data Connections (not recommended)”. Select OK, then exit and reopen your spreadsheet. The “Data Connections have been disabled” message should no longer display. Note: This will also work for Microsoft Word and other MS programs.
About Lillian Aaron is inspired by small and mid-sized businesses. She understands the challenges they face and the tenacity required to build strong, growing organizations.
![How to allow incoming connections on mac for excel mac How to allow incoming connections on mac for excel mac](http://cdn.osxdaily.com/wp-content/uploads/2013/08/firewall-options.jpg)
Select the radio button next to 'Allow all incoming connections' to completely disable the firewall. Select the radio button next to 'Set access for specific services and applications' to block all incoming connections with the exception of trusted services and applications. From here, you can configure the options and add applications to the list. An application you add to the list can have incoming connections allowed or blocked — your choice. In summary, a firewall isn’t really necessary on a typical Mac desktop, just as it isn’t really necessary on a typical Ubuntu Linux desktop.
Since 1983, Lillian has worked with businesses as a business process consultant helping them implement and support leading-edge products that drive efficiency and profitability for diverse clients. Her friendly, one-on-one consulting style helps business owners and managers feel at ease when adopting and learning new technology systems.