Impossible d'ajouter des couches depuis AGO dans ArcGIS pour Excel

Question

Bonjour la communauté,

J'ai déjà utilisé ce complément auparavant, mais maintenant je ne peux plus ajouter aucun de mes contenus depuis AGO à un classeur. Je peux voir mes couches, mais lorsque je sélectionne la couche ou choisis "Ajouter la table d'attributs à Excel...", on me demande sans cesse de me connecter à AGO (ce que je suis déjà). Je peux ajouter des couches publiques d'AGO et des couches du Living Atlas. Quelqu'un d'autre a-t-il rencontré ce problème ?

Merci

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.