"Show Map" Grayed

[PhillipLaFranca]

I use ArcGIS for Excel as part of a routing workflow. I use it as a guest. There's about 20 workbooks that are almost identical (data differs, formatting and UDFs are identical) that have a couple UDFs but are by and large quite simple (Store Numbers, Lat/Lon, etc.). They are all saved to my company's OneDrive

About a week ago, I just lost the ability to "Show Map". In very isolated scenarios the add-in has worked upon opening, but the only solution I've found thus far to resolve the problem is to completely remove the add-in, reinstall it, then open the workbook. This works precisely ONE time before the show map icon is grayed again. If I close the workbook and immediately re-open it, it will be grayed until I repeat the remove/reinstall.

Things I've tried (not in order):

• A wild goose chase ChatGPT sent me on messing with my DNS, cached data, and a myriad of other things. None of which worked...obviously

• Wiping and reinstalling Microsoft Office from my computer

• Saved .xlsm as a .xlsx

  • Moved the files to local storage, then repeated the above

[CoreyWilliamsESRIAccount]

I am also seeing this experience.  It works in a new workbook but is greyed out when the same workbook is reopened.

[WMANDD]

Same here, existing Workbook has it greyed out. This was working last week.
Tried Reset Map and nothing happens. Syncing data still seems to work, but the map panel won't display.

The Panel displays on the Online version but there is no Map inside of it.

[Chad_PMX]

I'm also having the exact same issue. It started on Thursday 4/9 for me.

[ShannonCardoza]

Thank you all for posting and apologies on the issues you are experiencing. I have reported this to my greater team. I will post here as soon as we have a chance to dive in!

[SoniaRicciardi]

I am also having the same issue, and it's really frustrating. An important file was using the adds in, and now it is no longer functional. I would really prefer to go back to what we were using before the update cause this is not useful at all

[ShannonCardoza]

Apologies on this issue @SoniaRicciardi, our team is diligently working to roll out a fix. Stay tuned....

[BrandonDrawhorn]

This is not the permanent fix I believe you are seeking, but have you tried clicking on the ArcGIS for Excel add-in from the home tab rather than uninstalling and reinstalling?

This started happening recently to me as well and since then I have found that I have to go to Home>Add-ins and click on ArcGIS for Excel every time I open the file. This obviously doesn't keep the map open after closing the file, but it is pretty fast. I hope this works for you.

[BrandonDrawhorn]

This is not the permanent fix I believe you are seeking, but have you tried clicking on the ArcGIS for Excel add-in from the home tab rather than uninstalling and reinstalling?

This started happening recently to me as well and since then I have found that I have to go to Home-Add-ins and click on ArcGIS for Excel every time I open the file. This obviously doesn't keep the map open after closing the file, but it is pretty fast. I hope this works for you.

[BrandonDrawhorn]

This is not the permanent fix I believe you are seeking, but have you tried clicking on the ArcGIS for Excel add-in from the home tab rather than uninstalling and reinstalling? This started happening recently to me as well and since then I have found that I have to go to Home-Add-ins and click on ArcGIS for Excel every time I open the file. This obviously doesn't keep the map open after closing the file, but it is pretty fast. I hope this works for you.