Select the Data Source

2. Try This: Select the XML File

The next step in the process is to Browse for the XML file. This screen shot shows the XML file in the Documents folder.

 

When you are prompted, find and select the sample XML file.

Click Open. Keep going...

 

 

 

Thoughts to Consider: Macro security is managed by Trust: Trusted Publisher, Location, or Trusted Document. Microsoft recommends that the XML file should be saved in a Trusted Location.

Data ->Get External Data->From Other Sources

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.1. Apply workbook settings, properties, and data options: Import XML data