Important: The data source definition contains connection information about the imported XML data. Clearing this option does not delete any data from the worksheet. ![]() In the XML Map Properties dialog box, under Data source, clear the Save data source definition in workbook check box. On the Developer tab, click Map Properties. On the File tab, click Options > Customize Ribbon. If the Developer tab is not available, do the following to display it: This procedure permanently removes the current data source definition from the XML map.Ĭlick a mapped cell to select the XML map that you want. In this case, you can still export the XML data. 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. Delete the data source definition of the XML map from the workbook Furthermore, if you save your workbook as a Macro-enabled Excel Open XML Format File, this map information can be viewed through Microsoft Notepad or through another text-editing program. ![]() A malicious user could view this potentially sensitive map information by using a Visual Basic for Applications (VBA) macro. Security Note: An XML map and its data source information are saved with the workbook, not with a specific worksheet.
0 Comments
Leave a Reply. |