Chart & Visualization Issues

Refresh Data and Fix County Mapping Errors in Excel 3D Maps

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

The user needs to correct county locations and refresh the data used by an Excel 3D Maps layer.

Refresh Data and Fix County Mapping Errors in Excel 3D Maps
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.
Before you start

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.

Solution 1Recommended

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.

1
Check county and state values

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.

2
Add the new column

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.

3
Refresh the map

Open the existing tour in 3D Maps and select Home > Refresh Data. The new column should become available in the map's field list.

4
Review geographic fields

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.

Correct the Excel source data and refresh 3D Maps
Warnings are not edited directly: Mapping-confidence warnings reflect how locations were interpreted. Correct the underlying data and field assignments, then refresh and check the results; a refresh alone may not resolve every ambiguous location.
Free Microsoft Office alternative

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.

Edit county and state source columns in WPS SpreadsheetsOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

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.