A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hello @Hannah,
Based on the image and your description, the issue might relate to Excel 3D Maps is failing to match your location data, which is why the map shows gaps, and the location accuracy is reported as 0%.
For my recommendation, there are some possible solutions for you to check if it can resolve the issue:
1/ Check Bind Maps/Online service issue
Navigate to Excel > Account > Manage Settings under Account Privacy tab > select “Turn on optional connected experiences”
2/ Custom Region mapping is no longer valid
In Excel, navigate to Home > Refresh Data > re-apply Custom Regions if they are still needed.
For further instruction regarding to Refresh Data, kindly visit: Get and prep your data for 3D Maps - Microsoft Support
3/ Testify on small postcodes
Copy 10 postcodes that you know should plot
Paste them into a new blank Excel file
Create a new 3D Map
Plot only those postcodes
If all the steps work, the issue might relate to data formatting, map configuration, or environment and service issues.
In case all steps have passed but the issue persists, kindly provide more information so that I can investigate further:
1/ Which Excel version are you using?
2/ Whether this worked recently on the same machine
3/ Can this file work normally on another device?
4/ If able, can you provide a screenshot of your Excel sheet?
Note: Please understand that as a forum moderator, my primary goal is to provide helpful guidance and support through general troubleshooting steps. While I don’t have access to internal systems or test devices required to resolve backend/account issues, I truly appreciate your understanding of these limitations.
I hope you find this information helpful. If anything is unclear, please don’t hesitate to reach out to me.
If you have any extra questions about this answer, please click "Comment."
If you want to receive the related email notification for this thread, please follow the steps in our documentation to enable e-mail notifications.