“We can’t connect to” in Excel

“We can’t connect to” pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are you will probably received an error message the moment you open the file. Excel files that are linked to databases tend to cause issues if sent outside of an intranet setting. This error is primarily due to incorrect formatting from the sender.

Regardless, every time you open the document, you may receive multiple error messages stating that Excel is unable “to connect to “https…” ,”We can’t connect to”, etc.

We can't connect to:
Microsoft Excel cannot access

There are two easy fixes

Non VBA Method

Click on Data > Queries & Connections

Queries & Connections

Now Right Click on the Connection and Hit Delete

Delete Connection

VBA METHOD

Launch the Macro editor and place the following VBA code. Now Run the Macro.

This will clear all of the data connections in the workbook.

Sub DeleteAllConnections()

Dim i As Long
For i = ActiveWorkbook.Connections.Count To 1 Step -1
  ActiveWorkbook.Connections.Item(i).Delete
Next 'i

End Sub

Leave a Reply

MINUTE Function

The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59. Syntax: =MINUTE(serial_number)

Read More »

CUMPRINC Function

The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This

Read More »
Scroll to Top