Excel Error Codes

How to Fix Internal Error (System.NullReferenceException) When Opening Excel 3D Maps

WPS Content Manager Sep 29, 2026 869 views

Question details

The user needs to resolve a System.NullReferenceException that occurs when attempting to launch 3D Maps in Excel.

How to Fix the Internal Error When Opening Excel 3D Maps

Product: Microsoft Excel
Device & OS: Windows
Scenario: Launching the 3D Maps (formerly Power Map) feature to visualize geographic or temporal data.
Observed behavior: Excel throws a System.NullReferenceException internal error, preventing the 3D Maps add-in from opening and functioning properly.

Before you start

Ensure your Windows operating system is fully updated, and save any open workbooks to prevent data loss before modifying add-ins or repairing Office installations.

Solution 1Recommended

Troubleshoot Add-in Conflicts via Safe Mode

Start Excel in Safe Mode to determine if another COM add-in is interfering with 3D Maps, and disable the conflicting extensions.

Often, third-party add-ins can conflict with Excel's built-in 3D Maps (Power Map) components, causing it to fail on initialization.

Launch Excel in Safe Mode

Press and hold the Ctrl key on your keyboard, then click the Excel shortcut to open it. Confirm that you want to start in Safe Mode when prompted.

Test 3D Maps

Attempt to open 3D Maps in Safe Mode. If it opens without the System.NullReferenceException error, a third-party add-in is the likely culprit.

Manage COM Add-ins

Navigate to File > Options > Add-ins. At the bottom of the window, change the 'Manage' dropdown to 'COM Add-ins' and click 'Go'.

Disable Conflicting Add-ins

Uncheck all third-party add-ins to disable them (leave Microsoft Power Map checked if visible), click OK, and restart Excel normally to verify the fix.

Troubleshoot Add-in Conflicts via Safe Mode

Add-in Isolation: You can re-enable your COM add-ins one by one to pinpoint exactly which add-in caused the crash.

Solution 2

Run a Repair on Microsoft Office

Use the Windows built-in repair tool to fix corrupted Microsoft Office or Microsoft 365 components that may be causing the error.

Solution 3

Recreate the Workbook or Transfer Data

Transfer your data into a fresh workbook to bypass the error if it is caused by file-specific corruption.

Free Microsoft Office alternative

Use WPS Office for Powerful Data Visualization

If Microsoft Excel continues to display internal errors or crash while loading heavy add-ins, consider switching to WPS Office. It provides robust spreadsheet tools and comprehensive charting options natively, avoiding the instability of third-party COM add-ins.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing .xlsx workbooks.
3. Visualize Your Data: Utilize the built-in Insert Chart tools to generate dynamic and stable data visualizations without external plugins.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Lightweight design ensures fast loading and prevents heavy add-in crashes.Completely free to use with a familiar, tabbed user interface.Rich built-in charts and data visualization tools ready right out of the box.

microsoft office alternative - wps office

Frequently Asked Questions

What causes the System.NullReferenceException in Excel?

This error typically occurs when Excel fails to load the 3D Maps (Power Map) COM add-in properly. It is often caused by conflicts with other third-party add-ins, corrupted Office installation files, or an outdated version of Excel.

Is 3D Maps available in all versions of Excel?

No. 3D Maps (formerly Power Map) is fully integrated into Excel 2016, Excel 2019, Excel 2021, and Microsoft 365. Older versions like Excel 2013 required downloading it as a separate Power Map preview add-in.

Will running an Online Repair delete my Excel files?

No. Using the Quick Repair or Online Repair options from Windows Settings only repairs the Microsoft Office application files. Your personal workbooks, documents, and data will remain completely untouched.

How do I clear the Power Map cache if it is corrupted?

While there isn't a direct 'clear cache' button for 3D Maps, you can often reset it by deleting the temporary files in your local AppData folder, or by going to File > Options > Data and clicking 'Clear Data' under the Data Model options.

Microsoft Office Error Codes