topic Re: How to retain color and symbology when editing maps in Excel in ArcGIS for Office Questions

How to retain color and symbology when editing maps in Excel

KonradHughes — Thu, 18 Apr 2019 19:18:13 GMT

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?

Re: How to retain color and symbology when editing maps in Excel

ShannonChavez — Fri, 19 Apr 2019 17:35:48 GMT

Good Afternoon Konrad,

Thank you for your question. I am hoping to help offer further assistance. In the meantime, can you confirm the version of Maps for Office you are currently using?

Best,

Shannon | Product Engineer

Re: How to retain color and symbology when editing maps in Excel

KonradHughes — Fri, 19 Apr 2019 17:38:41 GMT

Hi Shannon,

Thanks for assistance. It is version 5.0.0.805.

Re: How to retain color and symbology when editing maps in Excel

KonradHughes — Wed, 24 Apr 2019 13:14:08 GMT

Has there been any progress? I have reinstalled the most recent Maps for Office plugin and still experience the problem.

Re: How to retain color and symbology when editing maps in Excel

ShannonChavez — Wed, 24 Apr 2019 20:33:25 GMT

Hi Konrad, I do not have an update yet but have this on my radar for this week. I will be posting an update here. Thank you for your patience!

Re: How to retain color and symbology when editing maps in Excel

ShannonChavez — Wed, 24 Apr 2019 20:37:28 GMT

Hi again, now that I think about it, can you call Technical Support to get a case started? This will be beneficial for tracking and testing purposes.

Support Services can be reached by calling 1-888-377-4575. Please let me know if this is not an option.

Best,

Re: How to retain color and symbology when editing maps in Excel

ShannonChavez — Mon, 06 May 2019 20:34:11 GMT

Hi Konrad,

I was hoping you could confirm if these are similar steps in your workflow:

Open an Excel spreadsheet
Add Map from the ArcGIS Maps tab
Select Excel data from the map viewer
Insert Table (or data)
Change Map theme to Counts and amounts, select add data
In the style tab, deselect Cluster Points
Select Layer Styling
Keep the defaults, but choose a new color scheme via the Advanced Options menu
Observer the behavior of the bug

There may be a few steps missing here but I was hoping you could fill those in for me. This will help paint a clearer picture of the behavior so we can try to reproduce this?

Thank you,

Re: How to retain color and symbology when editing maps in Excel

KonradHughes — Mon, 06 May 2019 20:47:19 GMT

Step 5 would be to make the map theme Types (unique symbols)

Step 8 would be to change the color scheme and symbols using the Basic menu

Then right after Step 8, change the data in the map’s source spreadsheet and observe the bug.

Re: How to retain color and symbology when editing maps in Excel

ShannonChavez — Wed, 08 May 2019 16:39:34 GMT

Good Morning Konrad,

We will be addressing this issue. Thank you for logging this issue with our Technical Support team and for bringing this to our attention!

Best,