Delete the data source definition of the XML map from the workbook
If you want to keep using the map information but remove the potentially sensitive data source information, you can delete the data source definition of the XML schema from the workbook. In this case, you can still export the XML data.
This procedure permanently removes the current data source definition from the XML map.
- Click a mapped cell to select the XML map that you want.
- If the Developer tab is not available, do the following to display it:
- On the File tab, click Options > Customize Ribbon.
- Select the Developer check box.
- On the Developer tab, click Map Properties.
- In the XML Map Properties dialog box, under Data source, clear the Save data source definition in workbook check box.This option is selected by default. Clearing this option does not delete any data from the worksheet.
Delete an XML map from a workbook
If you delete a worksheet before deleting an XML map, the map information, about the data sources and possibly other sensitive information, is still saved in the workbook. If you are updating the workbook to remove sensitive information, make sure that you delete the XML map before you delete the worksheet so that the map information is permanently removed from the workbook.
- If the Developer tab is not available, do the following to display it:
- On the File tab, click Options > Customize Ribbon.
- Select the Developer check box.
- On the Developer tab, in the XML group, click Source.
- In the XML Source task pane, click XML Maps.The XML Maps dialog box is displayed.
- Select the XML map that you want to delete.
- Click Delete, and then click OK.
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
The bottom line is that I can no longer open Excel spreadsheets or Word docs sent to me.
This is an intolerable situation from a business point of view and I would be very much obliged to any of you who can point me in the right direction to solving this problem.
Remove Microsoft Open Xml Converter Online
Many thanks,Microsoft Open Xml Converter Mac
James