Excel on Macbook: “External Data Connections Have Been Disabled”

On a MacBook, Excel shows External Data Connections have been disabled when a workbook wants to reach an outside source—often a Power Query link to a Google Sheets CSV. It is a security prompt, not proof that your spreadsheet formulas are broken.

Excel for Mac Flags Disabled External Data Connections

Excel blocks or pauses the external connection until you decide whether to refresh. Excel for Mac does not currently expose the same Trust Center controls as Windows, so you may not find a permanent “always trust this connection” switch.

Decide Whether to Refresh or Remove the Connection

If you trust the source, enable or refresh the connection when Excel prompts you. If you want the warning gone and do not need live refresh, open a copy of the workbook, remove the connection under Data → Queries & Connections, then import the CSV manually when needed.

What Trips the External Data Connections Warning on Mac

• Power Query or other links pointed at Google Sheets, CSV URLs, or databases.
• Excel for Mac security prompts before contacting outside data.
• No Windows-style Trust Center option to permanently silence a specific connection.
• Workbooks shared from Windows that still carry external queries.
• Automatic refresh expectations that Mac Excel cannot suppress the same way.

Allow Refresh or Strip the Connection on a Copy

When to use this: Use this when Excel for Mac warns that external data connections have been disabled.

1. Decide whether you still need live refresh from the external source.
2. If yes and you trust the source, use Excel’s prompt to enable/refresh the connection for this session.
3. If you want to stop the warning, duplicate the workbook first so the original stays intact.
4. On the copy, open Data → Queries & Connections and remove the external connection you no longer need.
5. Import the CSV (or other file) manually when you need an updated snapshot.
6. Retest formulas that depended on the query so you know which ranges must be pasted as values.

Why this works: The message is Excel protecting you from silent external calls. Refreshing trusted sources—or removing unneeded connections—matches how Mac Excel can manage the risk today.

If this fails: Confirm whether the workbook relies on Windows-only query features and consider refreshing that workbook on Windows if Mac cannot complete the connection.

Handle Sheets in WPS While Excel Mac Blocks Connections

WPS Office cannot permanently trust Microsoft Excel Power Query connections or change Excel for Mac Trust Center options that do not exist. Connection policy stays inside Excel.

While you decide how to handle the warning, WPS Office can still open many local spreadsheets:

1. Install WPS Office on your Mac.
2. Open a static copy of the workbook for editing.
3. Continue analysis that does not require the live external query.
4. Return to Excel for Mac when you need to refresh or redesign the connection.

If you need a free spreadsheet app alongside Excel’s connection prompt, try WPS Office.

Prevent Surprise External Connection Blocks on Mac Excel

• Document which workbooks depend on Google Sheets or URL queries.
• Test shared Windows workbooks on Mac before relying on them in a meeting.
• Keep a manual CSV export path when live refresh is optional.
• Work on copies before deleting queries you might need later.

Common Follow-Ups on Excel Mac Data Connections

Can I permanently hide this warning on Excel for Mac?
Often no. Mac Excel may lack the Windows Trust Center controls for permanently trusting a connection.

Is the warning a virus alert?
It is a security prompt about external data, not an automatic malware verdict. Only refresh sources you trust.

Does WPS Office run the same Power Query connection?
Not as a drop-in replacement for Excel’s query stack. Use WPS for local editing when live refresh is not required.