Kan geen lagen van AGO toevoegen in ArcGIS voor Excel

Question

Hallo Community,

Ik heb deze add-in eerder gebruikt, maar nu kan ik geen van mijn content van AGO aan een werkmap toevoegen. Ik kan mijn lagen zien, maar wanneer ik de laag selecteer of kies voor "Attribuuttabel toevoegen aan Excel...", blijf ik gevraagd worden om in te loggen bij AGO (wat ik al ben). Ik kan wel openbare AGO-lagen en lagen van de Living Atlas toevoegen. Heeft iemand anders dit ook ervaren?

Bedankt

ShannonCardoza · Answer

Hey there @DerekMStrout, Nice investigating! Let me answer by questions, see below -

1. I could not reproduce the issue you referenced with filtering. For example, I have 67 items, I filtered by 'Feature layers' which gave me a count of 52, and then selected the clear filter button and the count went back to 67. As for layer settings, this would be managed in ArcGIS Online. I suspect this is specific to the layer and my guess is the 'authoritative' tag. Designated items tagged as authoritative have their own set of rules. See Designate items as authoritative for more.

2. For this issue, this could very well be a cause. I personally have not used Microsoft Forms. We may also be experiencing an unknown limitation if the resulting cells can have 3,000+ characters. I would need to test this further. Do you have a sample subset of data to share?

DerekMStrout · Answer

Hi @ShannonCardoza. I have been trying to use the add-in with Excel desktop (many different fresh workbooks), but I just tried it in Firefox, Chrome, and Edge with the same issue.

Two things I just noticed may indicate it's an issue with the layer itself.

1. When I first sign in to ArcGIS for Excel and search for my content, I see 2,429 items. But if I apply a filter like 'Feature layers' and then clear that filter, I am still left with just 246 items. This subset does not include the layer I am interested in. Are there layer settings required that I have overlooked? This is just a simple 157-point hosted feature layer tagged as Authoritative, with editing disabled and Export Data enabled.

2. The original spreadsheet was created from a Microsoft Form that accepted long form responses. Some resulting cells then have 3,000+ characters. The information displays fine in AGO, but could this be causing a problem when trying to view in Excel?

Thanks,
Derek

ShannonCardoza · Answer

Good morning @DerekMStrout , Thank you for reaching out. I have not experienced this issue. Can you try a few troubleshooting ideas please?

1. Clear browser cache and attempt the same workflow using the same workbook

2. Try the same workflow using a different Excel workbook

Please let me know your findings.