Power Query Problems

Fix Excel Get & Transform Data Options That Do Nothing

Nimra MalikNimra Malik Nov 13, 2026 869 views

Question details

The user needs Excel's Get & Transform Data options to respond when selected.

Fix Excel Get & Transform Data Options That Do Nothing
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user selects commands in the Get & Transform Data section to work with data in Excel.
Observed behavior
The options produce no visible response. The user also reported that Excel could not be used in safe mode.
Before you start

Confirm that the affected commands are under Excel's Data > Get & Transform Data section, and note your Excel version under File > Account > About Excel. The steps below are for Excel on Windows; if Excel safe mode cannot be used, continue with the clean boot and Office repair checks.

Solution 1Recommended

Test Excel Safe Mode and Disable Add-ins

Use this check to find out whether an Excel add-in is interfering with Get & Transform Data.

1
Start Excel in safe mode

Close Excel, press Windows+R, enter excel /safe, and select OK. If Excel does not open or cannot be used in safe mode, skip to the clean boot solution.

2
Test the commands

In Excel safe mode, open the Data tab and select an option in Get & Transform Data. Check whether it responds.

3
Disable add-ins

If the commands work in safe mode, restart Excel normally and go to File > Options > Add-ins. Choose COM Add-ins in the Manage box, select Go, clear the add-in checkboxes, and select OK. Repeat for Excel Add-ins if needed.

4
Identify the cause

Restart Excel and test Data > Get & Transform Data again. If it works, re-enable add-ins one at a time through File > Options > Add-ins, restarting and testing after each change.

Test Excel Safe Mode and Disable Add-ins
Free Microsoft Office alternative

Work With Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and support for common Excel formats, making it easy to move everyday spreadsheet work to WPS. It does not repair Excel's Get & Transform Data commands.

Open and edit spreadsheet data in WPS SpreadsheetsCompatible with common Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight for everyday Office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Where are the Get & Transform Data commands in Excel?

Open Excel and select the Data tab. The Get & Transform Data group contains commands for importing and working with data.

What if Excel cannot be used in safe mode?

Skip the safe mode test and try a Windows clean boot to check background software. You can also update Office from File > Account > Update Options or repair it through Windows Settings > Apps.

How can I tell whether an add-in is causing the problem?

If Get & Transform Data works in safe mode, restart Excel normally and disable add-ins under File > Options > Add-ins. Re-enable them one at a time, restarting and testing after each change.

Should I reinstall Office if a repair does not help?

If the commands still do nothing after updates, a clean boot, and Office repair, use Microsoft's official uninstall troubleshooter or Windows Settings to remove Office, then reinstall it from your Microsoft account or work account.