Excel XML Source pane does not have button to add an XML map
I am trying to add an XML map to an Excel workbook however my Excel doesn't have the "XML Maps" option in the XML source pane
Should look like this:
Actually looks like this:
I have no add-ins, I have repaired office, I have removed anti-virus
Any ideas please?
Thanks in advance! Clare
I know this is a pretty old post but this is the only thing on the internet I was able to find showing this exact problem. Posting my solution in case anyone else comes across this looking for answers.
I had to help a user with this exact issue today. Developer tab enabled, Source pane opens but doesn't show the buttons at the bottom. After popping out the Source pane and making it smaller, I could see the buttons. Seems like a display issue.
To fix it, in Excel go to File > Options and go to the General tab, at the top under User Interface options toggle to "Optimize for compatibility" and close and re-open Excel. The buttons should remain visible.
- How to embed a SVG into a Cell using Aspose.Cells
- Run-Time Error 91 (object variable or with block variable not set) on VBA Email code "mailItem.Display" after IF statements
- Deleting duplicate header rows
- mixed date converted from default mm/dd/yy in excel to dd/mm/yy
- Laravel validator and excel files error
- Need help aligning a table to a column based on similar values in one table field
- Index rows and columns unexpected results
- Ascii Art using VBA
- How to obtain the full-path names of files read with WorkbookConnections
- How can export all part of columns to pdf file with VBA code?
- Difficult to run
- Allow User Input in Empty Cells, Prevent Editing or Deletion in Occupied Cells
- Export Charts from Excel as images using Python
- Converting 32-bit xll Excel add-in to 64 bit: LNK1561 error
- Changing the Date Format for GROUPED dates in a PIVOT TABLE
- VBA Filter Column Store Unique Values of Another Column
- How do I use checkboxes in an IF-THEN statement in Excel VBA 2010?
- Automatic numbering in Excel with hierarchy
- convert a C# datetime object into Excel date format
- Excel Find and replace using variables
- How to do a row-wise sum in an array formula in Excel?
- Putting Textboxes into array for formatting
- Code inserting and copying to the wrong worksheet
- how to use inequality filter in pivotby formula on aggregated values, not table data
- Excel XML Source pane does not have button to add an XML map
- Get values from available column in a row to the first column of the same row
- VBA - Worksheet.activate not working
- Transform datatable from column-based to row-based
- Check for consecutive characters in an excel cell
- Add text to first available cell in range with non-contiguous cells