ArcGIS for Excel: Map doesn't display when workbook reopened

Question

Previously working map with several layers doesn't display when workbook reopened.  Just see the ArcGIS for Excel icons and white space where the map should display.  See attached screenshot.

I can see the list of layers if I click on the layers icon, but clicking the carat icon for each just shows "No legend".  Signing in again doesn't help.

Using ArcGIS Enterprise 10.9.1.

Any ideas what might cause this?  Thanks!

EricKlein1 · Answer

Hi, @ShannonCardoza , Thanks for following up.  We recently transitioned our users from Enterprise 10.8.1 to ArcGIS Online, so we don't have a lot of history with this particular application when logged in to AGO; however I haven't heard of any issues yet from the group that was using this.

ShannonCardoza · Answer

Good morning @EricKlein1, we recently had a new version deployed. I'm curious to see if you are still experiencing this issue (or any other SSO issues).

Thank you kindly,

SC

EricKlein1 · Answer

Thank you for your research and response.  While the Reset Map button does indeed allow sign in to a different portal, it also completely wipes out the existing map, so does not appear to be useful as a mechanism to recover the previously-created map.

I think a key question here is how well does ArcGIS for Excel, when a map has been created while connected using an SSO-based sign-in handle the situation when the original authorization token expires.

I'll ask the user to try, for now, to see if he can recreate his map while signed in to ArcGIS Online using a built-in account rather than signed in to ArcGIS Enterprise using an SSO based signin.  That said, our organization is mandating that we shift to SSO-based signins on ArcGIS Online in the near future so a built in account might not be a viable long term solution.