ArcGIS for Excel Constantly Losing Connection to Added Layers
Hi,
Just wondering if anyone else has issues with ArcGIS for Excel losing connection to layers added to the spreadsheet? I have a couple of Excel files that I edit every month or so that contain multiple layers from ArcGIS Online via the add-in. I spend time formatting the data in these layers using filters and highlighting certain columns to make them easier to work with but I'm constantly having to redo this as the add-in often fails to recognise that my tabs are from ArcGIS Online. Below shows the map window effectively saying there are no GIS layers within the map window (N.B. my layers are feature tables) but the three blue tabs below are all AGOL feature services that I have worked on in the spreadsheet previously. This loss of connection tends to happen between sessions but I have another spreadsheet where I've seen it lose connection during a session which has meant edits I've made in Excel will not sync to AGOL.
Has anyone else seen this kind of issue and if so is there anything that can be done to prevent it? Is there a way to re-establish the connection without just adding the layers in again?
The ArcGIS for Excel add-in has the potential to be a game-changer for working with online datasets but I find it increasingly frustrating that the connections to my datasets often get lost meaning I have to re-do a lot of the formatting or I can't be sure if my edits will sync.
Any assistance would be much appreciated.
Thanks
Anthony
