Get & Transform data option on Excel not working

Question

Hi,

I am facing an issue with Excel "Get & Transform Data" option. I have build excel spreadsheets that have been working fine with this option - connecting to text files, databases, SalesForce, .. But now when I connect to the existing files with the connection and refresh the data, I get the following error message.

When I try creating a new connection, I see the option for connecting, but on clicking it, nothing happens. Please assist.

Regards,

Mohan

Answer 1

Hello Mohan

I am V. Arya, Independent Advisor, to work with you on this issue.

There is a possibility that an Add-in is creating problems. To test this hypothesis, start Excel in safe mode (How to - https://support.office.com/en-us/article/open-o... )

If you don't face the issue, then one of the add-ins will be the culprit. Now you can start application normally and you can disable all of them (File -- Options -- Add-ins) and enable them one by one and check to catch the culprit add-in.

Next option would be the usual repair to solve any issue with Office installation.

Press Windows key, hold it and press r to open Run window.

Type appwiz.cpl and press enter

This will open Uninstall or change a program window

Click Office in the list of program

Click Change at top

Select Online repair

Restart your computer once Online repair is finished.

Let me know the outcome.

Answer 2

Thanks Arya for your quick response.

The safe mode option did not work, but the second option of Online repair reinstalled the application, and is working now.

Regards,

Mohan