How can I enable the Export option in the Developer Tab in Excel worksheet?

Anonymous
2024-04-10T18:28:05+00:00

I'm trying to export .xml data (actually a ternary diagram, to .xml), to work in another software. I follow the help procedures, but under the Developer tab in Excel, the option "export" keeps greyed, despite the fact that I select the area with algorithms (Map), that represent the ternary diagram template. I don't know if I have to choose any other parameter to activate the "export", though I tried several of them.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Anonymous
    2024-04-11T02:41:39+00:00

    Save as >Choose ".XML"

    The option in developer is for xml maps.

    0 comments No comments
  2. Anonymous
    2024-04-11T14:28:24+00:00

    When I try to save as .xml, the following message appear:

    So, whe following the Help page, I have to go to "Developer - Export" maps, as mentioned above.

    0 comments No comments
  3. Anonymous
    2024-04-11T14:53:49+00:00

    This problem occurs in Save As dialog box when you try to specify XML Data (.xml) in the Save as type list.

    This error occurs because an XML map is not yet applied. Open XML Source task pane by clicking the Source button in Developer tab and select the elements or entire nodes in the XML map and drag them into the worksheet. If the XML Source task pane is blank, add the XML maps.

    Cannot Save or Export XML Data in Excel – BrainBell

    Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

    0 comments No comments