|
6. Try
This: Find the Map Properties Go to
Developer ->XML. Click on
Map Properties. What Do
You See? The XML Map Properties include the following: Name XML schema
validation Data
Source: this option lets you Save the data source definition in the
workbook. Data
formatting and layout What
Else Do You See? The XML Map Properties determines what
happens when the data is refreshed or imported.
There are two very different choices: Overwrite
the existing data with new data Append new
data to an existing XML table The
default is to overwrite (replace) the data when you refresh or
import. So far so
good. Click OK!
Developer ->XML->Map Properties
Exam 77-888: Microsoft Excel Expert
2010
1. Sharing and Maintaining Workbooks
1.1. Apply workbook settings,
properties, and data options: XML Map Properties |
|
| |
