Fix Excel Maps Not Showing All Norwegian Counties
Question details
The user is experiencing issues with Excel 2D Maps where Norwegian counties are displayed with outdated names, incorrect boundaries, or inappropriate sea area inclusions following recent administrative changes in Norway.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating geographic data visualizations using Excel 2D Maps for regions in Norway.
- Observed behavior
- Excel Maps fails to recognize new Norwegian county boundaries, displays incorrect borders that include sea areas, and only plots data correctly when former pre-change county names are used in the dataset.
Ensure you have a stable internet connection, as Excel 2D Maps requires online access to Bing Maps to render geographic data. It is also recommended to update your Office application to the latest version to ensure you have the most recent data patches.
Use Former Norwegian County Names in Your Data
Since Excel's mapping service has not fully updated to reflect Norway's new county structure, using the older, recognized county names ensures your map renders correctly.
This is currently the most reliable workaround for the mapping limitation. The Bing Maps service integrated into Excel still relies on the legacy geographic boundaries for Norway.
Open your Excel workbook and locate the column containing your geographic data and Norwegian county names.
Replace the newly established county names in your cells with their former names (the pre-administrative change names) that the mapping service still recognizes.
Select your updated data range, go to the 'Insert' tab on the ribbon, and click 'Maps' to generate the 2D Map again with the recognized names.

Submit Feedback to Microsoft for Map Data Updates
Reporting the geographic data inaccuracy directly to Microsoft helps prioritize the backend update of Bing Maps data used in Excel.
Try WPS Office for Your Data Visualization Needs
If you are frustrated by unresolved bugs and server-side data limitations in Microsoft Excel, WPS Office offers a free, highly compatible, and lightweight alternative for your spreadsheet and charting tasks.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open your data files: Launch WPS Spreadsheet and open your existing .xlsx files containing your regional data without losing any formatting.
- 3. Create alternative visualizations: Use WPS Spreadsheet's built-in, offline-friendly chart tools to create clear, accurate bar or pie charts for your regional data while waiting for Microsoft's map updates.

Frequently Asked Questions
Why does Excel Maps show incorrect boundaries for Norway?
Excel 2D Maps relies on the Bing Maps service for its geographic data. This service has not yet been updated on Microsoft's end to reflect Norway's recent administrative county changes, resulting in outdated borders and misaligned sea areas.
Can I manually fix or redraw the map boundaries in Excel?
No, the map boundaries are pulled directly from the cloud-based Bing Maps service. Users cannot manually edit, adjust, or redraw geographic boundaries within the Excel 2D Maps feature.
How long does it take for Microsoft to update map data in Excel?
Updates to Bing Maps and Excel's mapping service occur periodically on Microsoft's end without a publicly announced schedule. Submitting feedback through the Excel app is the best way to bring attention to specific regional inaccuracies.
Are there alternative ways to visualize this regional data?
If geographic accuracy is critical and 2D Maps fails, consider using standard bar charts, column charts, or pie charts to represent your regional data metrics, or use dedicated GIS (Geographic Information System) software for precise mapping.




