Nelze přidat vrstvy z AGO v ArcGIS pro Excel

Question

Ahoj komunito,

používal jsem tento doplněk dříve, ale nyní nemohu přidat žádný ze svých obsahů z AGO do sešitu. Vidím své vrstvy, ale při výběru vrstvy nebo volbě „Přidat atributovou tabulku do Excelu...“ se mi stále zobrazuje výzva k přihlášení do AGO (už jsem přihlášen). Mohu přidávat veřejné vrstvy AGO a vrstvy z Living Atlas. Zažívá to ještě někdo?

Díky

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.