Select to view content in your preferred language

ArcGIS for Excel - Attributes in Excel Not Dynamically Updating

772
5
12-19-2023 06:12 AM
MelissaSalich
Occasional Contributor

I am using ArcGIS for Excel connected to my organization's Portal environment. 
I can load the feature services and bring in their associated data as sheets in Excel. 
When data is edited, Excel does not dynamically update. 
I've tried refreshing the data with right clicking the hamburger menu and closing/reopening. 

How do I configure ArcGIS for Excel to update when the service is updated?

0 Kudos
5 Replies
ShannonCardoza
Esri Contributor

Good morning @MelissaSalich Thank you for posting your question. ArcGIS for Excel does not support dynamic updates (or two-way syncing). Once edits are made, you may reshare the layer/map or select update (one-way sync). 

Please let me know if you have any other questions. 

Best, 

SC

Shannon Cardoza
Product Engineer
0 Kudos
MelissaSalich
Occasional Contributor

How do you select update for one-way sync? Is it on the feature layer or within ArcGIS for Excel?

0 Kudos
ShannonCardoza
Esri Contributor

Hey there @MelissaSalich my apologies, did not mean to cause confusion. ArcGIS for Excel does not support dynamic updates. There is no setting for this. 

Shannon Cardoza
Product Engineer
0 Kudos
MelissaSalich
Occasional Contributor

Update: BUG-000164342

ArcGIS for Excel does not show the refresh icon after the excel file is created, therefore not allowing data to dynamically update. Excel v 2302 Build 16130.20868.

ShannonCardoza
Esri Contributor

Thanks for getting this logged @MelissaSalich I will work with my team and provide an update once I have one. 

-SC

Shannon Cardoza
Product Engineer
0 Kudos