I’ve run into a base map issue with one specific Excel workbook linked to our ArcGIS Online web map.
I keep getting an "The basemap is unavailable or has been deleted from the server."
I am just using the default basemap's that are provided, so no custom base map.
It appears this issue started after I started writing formulas one sheet that reference the dynamic Attribute table I added into my excel from the ArcGIS for Excel add in.
I am not sure if that is the culprit, but it appears to have triggered the base map corruption.
So far after extensive testing:
What works:
What fails:
Only this one workbook immediately throws:
Error code 3002: BasemapLoadError: Check the basemap service or select a different basemap.
Because the error fires on load, the Reset Map and Clear Cache buttons remain disabled, so I can’t clear the embedded cache.
Actions tried so far:
Cleared the global add-in cache (%LOCALAPPDATA%\Microsoft\Office\16.0\Wef).
Extracted and removed Custom XML parts (/xl/webmap) from the .xlsx package.
Re-saved the web map in ArcGIS Online to ensure version compatibility.
Despite these steps, the basemap still fails to load and I can’t trigger an in-UI cache clear.
2 questions here.
1. Has anyone else seen this? I see a comment on one of
@ShannonCardoza's blog post on the latest update to ArcGIS for Excel.
2. Has any one successfully used Excel formulas (e.g. VLOOKUP, INDEX/MATCH) to pull data from the ArcGIS for Excel dynamic attribute table into a different sheet?