Não é possível adicionar camadas do AGO no ArcGIS para Excel

Question

Olá Comunidade,

Eu já usei este add-in antes, mas agora não consigo adicionar nenhum dos meus conteúdos do AGO para uma planilha. Consigo ver minhas camadas, mas ao selecionar a camada ou escolher "Adicionar tabela de atributos ao Excel...", continuo sendo solicitado a fazer login no AGO (já estou logado). Consigo adicionar camadas públicas do AGO e camadas do Living Atlas. Alguém mais está passando por isso?

Obrigado

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.