Auto Update Feature for Existing Maps

If you have a workbook containing maps from a previous release that have had new fields exposed, you can use the Map Version feature to update the maps, eliminating the need to re-map the workbooks to reflect those changes.

 

There are two ways to trigger the update.

 

Option 1

1.Open the previously mapped worksheet that contains the old version of the map.
2.In the Data Import ribbon, select Update Maps.

update maps 9.0

 

A list of all maps contained in the workbook appear. The Current column shows a Yes or No update status.

excel add in update map versions 8.2.14

 

3.Select the map to update and then click Update.

excel add in Map Versions select update map

 

4.A message appears asking if you want to continue. Click OK.

validation update all maps

5.The maps for all sheets in the workbook are updated, and the new fields appear in the Source Pane.

Note: You can select the Map Versions option at any time to review or select versions of a mapped file.

 

Option 2

1.Open the previously mapped worksheet that contains the old version of the map.
2.In the Data Import ribbon, click Validate Data.

validate data 9.0

 

3.If no errors exist a validation message appears. Click OK to complete the validation in the current workbook.

validation complete w no errors

4.The maps for all sheets in the workbook are updated, and the new fields appear in the XML Source pane.