XML export function in Developer Tab not available

Question

Hello!

I am trying to follow this tutorial.

https://blog.udemy.com/excel-to-xml/

But in my Developer Tab, in the XML section, I only have one option: "Source".

All other options are not there (Map Properties, Expansion Packs, Refresh Data, Export, Import)

I have looked for the buttons in the Customize Ribbon options but, even with all buttons displayed, they are not there.

Is there some setting to do with the file or Excel that I need to change to enable this function?

I'm using Microsoft Office Standard 2016

Thanks for your help!

Answer 1

Hi Minkiton. I’m RN, an Independent Advisor and Microsoft user like you.

I'm sorry to hear about this issue.

May you try to run your Excel in safe mode?

1. Find the shortcut icon for your Office application.
2. Press and hold the CTRL key and double-click the application shortcut.
3. Click Yes when a window appears asking if you want to start the application in Safe Mode.

If there is no issue in the safe mode, possible that there are add-ins that blocks you from using the Developer options while in normal startup. Check add-ins and disable them while in safe mode, then restart Excel and open it in normal mode to see if you can access the XML functions.

If problem persist, completely uninstall Office with the uninstall support tool (option 2) and install it again. See article below.

https://support.microsoft.com/en-us/office/unin...