I'm wondering if it's possible to re-map the source of my location feature class when errors pop-up in an excel sheet that contains an embedded ArcGIS for office map. I recently had to establish a connection between my excel table and location feature class from scratch (I had 2 polygon layers on ArcGIS Online and I think deleted the one that was connected to my excel sheet). Each time I do this I have to manually update my layer style including the attribute that I want the features to symbolize on and the symbol fill/outline. Is there a way to re-map the feature class source like we can do in ArcGIS Pro? i.e. go to the layer properties and Set Data Source.
After re-establishing the connection to my AGOL layer and updating the symbology, I attempted to fix some of my map errors by adding missing polygons to my feature class on ArcGIS Online. I've added 1 new feature to AGOL but still see the error in my excel sheet! Does this mean that I have to re-map my connection again?!
Can someone please let me know if there is a better way to updated my location source layer? I would like to establish a more efficient way to update my excel sheet/AGOL features.
