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?