Restore Missing XML Commands on the Excel Developer Ribbon
Question details
Restore the missing Map Properties, Import, and Export commands on the Excel Developer ribbon.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs to work with XML data using commands on the Developer tab.
- Observed behavior
- Excel shows XML Source, but Map Properties, Import, and Export are missing. If the commands appear in Safe Mode, an add-in or startup component may be responsible.
Open the affected workbook and check the Developer tab's XML group. Note which commands are missing; commands that are visible but grayed out may require an XML map or a suitable workbook.
Use Excel Safe Mode to identify a conflicting add-in
Use this method on Windows to compare the XML commands in Safe Mode and normal mode, then isolate a conflicting add-in.
Close Excel. Press Windows+R, enter excel /safe, and select OK.
Open the affected workbook and select Developer. Check whether Map Properties, Import, and Export appear in the XML group.
Close Safe Mode and reopen Excel normally. Go to File > Options > Add-ins. Select COM Add-ins from the Manage list and click Go.
Clear one add-in's checkbox and click OK. Restart Excel normally and check Developer > XML. Repeat for each add-in until you find the conflict.
If COM add-ins are not responsible, return to File > Options > Add-ins, select Excel Add-ins under Manage, and test them one at a time. If the issue persists, ask your IT administrator to review Excel startup components.

Check the Developer tab and XML map
Use this check if the Developer tab is hidden or the XML commands are visible but unavailable.
Edit Excel Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and moving between office suites. It does not repair Microsoft Excel's XML ribbon commands.

Frequently Asked Questions
Why do the XML commands appear in Excel Safe Mode?
Safe Mode starts Excel with fewer add-ins and startup components. If the commands appear there but not normally, test add-ins through File > Options > Add-ins to find a possible conflict.
How do I turn on the Developer tab?
In Excel, go to File > Options > Customize Ribbon, check Developer under Main Tabs, and click OK.
Why is an XML command grayed out rather than missing?
Some XML actions depend on the workbook and its XML map. Open Developer > Source > XML Maps to check whether an appropriate map is available.
Does WPS Office restore Excel's missing XML commands?
No. WPS Office is an alternative for opening and editing Excel workbooks; troubleshooting Excel's Developer ribbon must be done in Excel.




