Fix Missing Custom Regions in Excel 3D Maps After Reopening
Question details
The user is experiencing an issue where custom regions imported from a Shapefile disappear in Excel 3D Maps after closing and reopening the workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing and visualizing custom map boundaries via Shapefiles (.shp) in Excel 3D Maps for Region chart types.
- Observed behavior
- The custom regions display correctly upon initial import, but the Region chart type loses these regions after the Excel file is closed and reopened. Reloading the Shapefile only offers a temporary fix.
Ensure your Microsoft Office application is fully updated to the latest version, as 3D Maps rendering issues are frequently patched in newer builds. Keep a backup copy of your original Shapefile (.shp) and Excel workbook before proceeding.
Verify File Integrity and Update Office
Test the workbook on another computer or with a different Shapefile to rule out file-specific corruption or version-specific bugs in your Excel build.
In some versions of Microsoft Office, particularly older builds like Office Professional Plus 2016, the internal data model may fail to retain custom region data across sessions. Cross-testing helps isolate whether the issue lies with the specific .shp file or the software environment.
Open the affected workbook on a different computer running Microsoft 365 or a newer Excel version. Check if the custom regions load automatically when opening the 3D Map tour.
In your 3D Maps window, remove the current custom region mapping. Reload a fresh, uncorrupted copy of your .shp file. Save the workbook, close Excel entirely, and reopen it to test stability.
Go to File > Account > Update Options and select 'Update Now'. Allow the system to download and install the latest patches, which often include bug fixes for Power Map and 3D Maps.

Re-import Custom Regions to 3D Maps
Clearing the existing mapping and re-importing the custom region data can resolve temporary rendering glitches in the workbook's data model.
Switch to WPS Office for Reliable Data Visualization
If you frequently encounter stability issues or bugs with Microsoft Excel's advanced add-ins, consider trying WPS Office. It provides a highly compatible, lightweight, and completely free alternative for your daily spreadsheet and charting needs, without the heavy resource demands.
- 1. Download and Install: Visit the official WPS website to download the free installation package tailored for your operating system.
- 2. Open Your Data: Launch WPS Spreadsheets and directly open your existing .xlsx files without needing any format conversion.
- 3. Create Visualizations: Select your data range, navigate to the Insert tab, and choose from a wide variety of stable, built-in chart types to visualize your data.

Frequently Asked Questions
What file formats does Excel 3D Maps support for importing custom regions?
Excel 3D Maps primarily supports ESRI Shapefiles (.shp) and KML/KMZ files for importing custom regional boundaries. Ensure your Shapefile uses the WGS 84 coordinate reference system for accurate mapping.
Why is the 3D Map button grayed out in my Excel ribbon?
The 3D Map feature may be grayed out if your data is not properly formatted, or if the 'Microsoft Power Map for Excel' COM add-in is disabled. You can enable it by going to File > Options > Add-ins, selecting 'COM Add-ins' from the Manage dropdown, and checking the Power Map box.
Can I share an Excel 3D Map with someone who doesn't have the original Shapefile?
Yes, once a Shapefile is successfully imported into 3D Maps, the custom region data is embedded within the Excel workbook's internal data model. However, rendering glitches occasionally require access to the original file to re-import the data.
How do I fix 3D Maps crashing when loading large custom regions?
Large Shapefiles with highly detailed polygons can cause memory issues in 3D Maps. Try simplifying the polygon geometry using third-party GIS software before importing the .shp file into Excel, and ensure you are running the 64-bit version of Microsoft Office.




