Select to view content in your preferred language

ArcGIS for Excel edits not pushing to AGOL Hosted Feature Layer

367
5
03-05-2024 11:05 AM
HHight
by
New Contributor II

I am currently using ArcGIS for Excel to have users edit the tabular data for a particular hosted feature layer. The edits made in Excel are not being pushed to AGOL. However, edits made in AGOL do push to the Excel spreadsheet. I've tried refreshing the data on both ends, signing in and out, and ensuring I am using the correct feature. I cannot for the life of me figure out what is going on.

Any insight that can be provided is appreciated!!

Tags (3)
5 Replies
Gaurav-Singh
Esri Contributor

Please clear the cache to see whether it helps - https://doc.arcgis.com/en/microsoft-365/latest/excel/faqs.htm#anchor20

Please also verify that the 'Enable Editing' option is turned on for the ArcGIS layer you would like to edit.

GauravSingh_0-1710869880880.png

 

ArcGIS for Excel Team
0 Kudos
HHight
by
New Contributor II

Thanks for the reply!

I have ensured the data is editable. I have also cleared my cache and tried editing in different browsers. I am still unable to push edits from the spreadsheet.

0 Kudos
Gaurav-Singh
Esri Contributor

Could you please share the dev console log with us, including of the event when you edit the sheet? If possible, I would appreciate if you could direct message me the ArcGIS layer URL so that I can attempt to use it in my environment for debugging purposes. I assume your account User type is Creator and your account Role is Publisher. Thank you.

ArcGIS for Excel Team
0 Kudos
DerekMStrout
Occasional Contributor

I am also having issues pushing attribute updates in ArcGIS for Excel. I am able to make single attribute edits, but when copying and pasting a group of rows from a column of another Excel workbook, I get the error "Editing is not permitted, and changes will not be saved." I have editing enabled on the layer and just cleared the add-in cache. Is it possible that copying and pasting (using CTRL+C, CTRL+V and other methods) is not allowed?

0 Kudos
ShannonCardoza82
New Contributor

Good morning @DerekMStrout,

After chatting with my Developer, we have some follow-up information regarding the error message you are receiving. This error will occur with the following possibilities:

1. When the layer isn't editable. (In your case, it shouldn't be this cause because editing is enabled)
2. When one of the fields isn't editable. (Can you check that the fields pasted into have editing enabled?) 
3. When A4E attempts to edit but the AGOL server responds with HTTP status error 400 (bad request).
See https://support.esri.com/en-us/knowledge-base/error-error-code-400-message-unable-to-complete-operat... (If its not #1 or #2, we'll need to know the request sent to AGOL and what response AGOL sent back. Can you share network traffic so we can inspect the request that was generated when you pasted the data?)

Please let me know what you find out. 

Thank you kindly, 

SC

0 Kudos