topic Re: Refresh map in arcgis for excel after pivot table update in ArcGIS for Excel Questions

Refresh map in arcgis for excel after pivot table update

MarkCooper5 — Fri, 02 Feb 2024 15:02:11 GMT

I have used ArcGIS for Excel to procuce a map from a pivot table aggregating the number of inspections by Parish. When I change the filter on the pivot table, it does not automatically update the map and you appear to have to go into the layer and click reload. Is there a way this can be done automatically?

Re: Refresh map in arcgis for excel after pivot table update

ShannonCardoza — Mon, 05 Feb 2024 19:41:34 GMT

@MarkCooper5 Awesome request and completely understandable that having to reload or refresh is a bit unfit with this workflow. However, at this time, we do not have a workaround to provide. I will bring this idea (auto refresh) to the rest of my team...

Stay tuned!

Re: Refresh map in arcgis for excel after pivot table update

dcallaghan — Thu, 15 Aug 2024 16:28:57 GMT

@ShannonCardoza If there is an Community Idea for this post, I would like to upvote it. I think the ArcGIS for Excel add-in is genuinely fantastic, but the lack of auto-refresh for pivot table data sources seems like a missed opportunity to me.
It would be brilliant to see this feature in future

Re: Refresh map in arcgis for excel after pivot table update

ShannonCardoza — Wed, 21 Aug 2024 19:49:09 GMT

@dcallaghan Thank you for upvote! Let me take this workflow and feedback to our greater team. We have some excel-lent (pun intended) stuff in the works. Stay tuned.....😊