Quick Tips for Microsoft Office

December 13, 2011

Enabling data connections for Microsoft Excel, Word, Outlook

Have you noticed in Excel you sometimes cannot update your spreadsheet used to pull information from other programs? Chances are there is a Security Warning message on the top left that says “Data Connections have been disabled”. This is a safeguard designed to protect your system from potential harm.

Microsoft’s security warning does give you the option to enable the connections so that you can continue with your work. However, if you feel that you only open safe data files and want to enable the content automatically, here’s how to do it in MS Excel:

  1. Open Microsoft Excel, click on File on the top left
  2. Select Options, Trust Center, Trust Center Settings
  3. External Content (on the left), then select “Enable all Data Connections (not recommended)”
  4. Click OK, then exit and reopen your spreadsheet. The “Data Connections have been disabled” message should be gone.

Note: This will also work for Microsoft Excel, Word and other Microsoft programs.

Topics: Technology, Accounting & Finance

Lillian Aaron

Accounting Software Consultant, Porte Brown CPA

Lillian is a business adviser with more than 30 years of experience assisting small to medium businesses prosper by selecting the correct business accounting tools based on their specific needs. Her specialty is in process workflow—helping companies gain efficiency in their operations. Businesses seek her help when they have outgrown their basic accounting systems and are ready for a customized, robust solution that is still affordable. Lillian is an expert in a number of systems including Traverse ERP, Open Systems, and QuickBooks Enterprise and Method CRM. Specialties: Traverse Accounting Software, Open Systems Accounting Software (OSAS), QuickBooks Enterprise, Method CRM Her clients say, “Lillian is my go-to person when it comes to accounting software. She has a deep knowledge of available options and takes time to understand the needs of her clients,” “I found her to be of the highest integrity and extremely knowledgeable,” and “She is always willing to go the extra mile to make sure that her clients get exactly the solution they need.”
Read more articles from Lillian Aaron

Guide to Business Borrowing

Learn what banks are looking for when they prepare to make loans. Our guide covers what business owners need to know when they prepare to borrow.


Download eBook