Refresh Data and Fix County Mapping Errors in Excel 3D Maps
Question details
The user needs to correct county locations and refresh the data used by an Excel 3D Maps layer.

- Product
- Microsoft Excel 3D Maps
- Device & OS
- not provided
- Scenario
- A county KML layer is used in a 3D Maps visualization, and the user wants counties associated with the correct states.
- Observed behavior
- Some counties appear in the wrong states, and mapping-confidence warnings cannot be edited directly.
Locate the Excel table that supplies the map and identify its county and state columns. If the layer uses a KML file, locate that file as well so you can verify its region names and boundaries.
Correct the Excel source data and refresh 3D Maps
Use this method to update location fields and make new columns available without recreating the existing layer.
In the source Excel table, correct misspelled or mismatched county and state values. Add a separate state column if the county names need more geographic context.
Select the new column in the table, then choose Add Selected Data to 3D Maps from the 3D Map options on Excel's Insert tab.
Open the existing tour in 3D Maps and select Home > Refresh Data. The new column should become available in the map's field list.
In the layer's field list, check that the county and state columns are assigned to the appropriate geographic fields. Review the map and any remaining mapping-confidence warnings.

Check the KML source for incorrect county regions
Use this check if the Excel values are correct but a custom KML region still appears in the wrong place.
Edit Geographic Source Tables with WPS Spreadsheets
WPS Office is a free, lightweight alternative for working with spreadsheet data in a familiar interface. Open compatible Excel files and update county and state columns as you move between office suites. Excel 3D Maps mapping errors still need to be resolved in Excel.

Frequently Asked Questions
Why is a county shown in the wrong state in 3D Maps?
County names can be ambiguous or source values can be incorrect. Check the county and state columns in the Excel table, assign the appropriate geographic fields in the layer, and select Home > Refresh Data in 3D Maps.
How do I add a new state column to an existing 3D Maps layer?
Add the column to the source table, select it, and choose Add Selected Data to 3D Maps from the 3D Map options on Excel's Insert tab. Open the tour and select Home > Refresh Data, then add the field from the layer's field list.
Can I edit a mapping-confidence warning directly?
No. Correct the underlying location data or geographic field assignments, refresh the map, and review the warning again.
Will refreshing Excel data also fix an incorrect KML boundary?
Not necessarily. Check and correct the boundary in the original KML file, then update or reimport the custom regions in 3D Maps as needed.




