Fix Excel Get & Transform Data Options That Do Nothing
Question details
The user needs Excel's Get & Transform Data options to respond when selected.

- 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.
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.
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.
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.
In Excel safe mode, open the Data tab and select an option in Get & Transform Data. Check whether it responds.
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.
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.

Use a Windows Clean Boot to Check Background Software
Test whether a background service or startup app is preventing Excel commands from responding.
Update, Repair, or Reinstall Microsoft Office
Use these steps if the problem persists or Excel cannot be used in safe mode.
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.

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.




