AnsweredAssumed Answered

How to retain color and symbology when editing maps in Excel

Question asked by Missouri_EMGIS on Apr 18, 2019
Latest reply on May 8, 2019 by SChavez-esristaff

I currently have a spreadsheet with various locations in Excel, tied to a map in the spreadsheet using Maps for Office.  I have the locations symbolized by color based on a field called "Status" in the spreadsheet, with "Status" restricted to a list of options that I've defined.

My problem is that, when I change the value of "Status" for an entry in my spreadsheet, my symbology and color scheme in the map reverts to the default.  I lose all of my symbols and color codes I've made to represent the different possible values for "Status."  Is there a way to prevent that from happening?