Kann keine Layer aus AGO in ArcGIS für Excel hinzufügen

Question

Hallo Community,

Ich habe dieses Add-in schon früher verwendet, aber jetzt kann ich keinen meiner Inhalte aus AGO zu einer Arbeitsmappe hinzufügen. Ich sehe meine Layer, aber wenn ich den Layer auswähle oder "Attributtabelle zu Excel hinzufügen..." wähle, werde ich immer wieder aufgefordert, mich bei AGO anzumelden (was ich bereits bin). Ich kann öffentliche AGO-Layer und Layer aus dem Living Atlas hinzufügen. Hat noch jemand dieses Problem?

Danke

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.