ArcGIS for Excel が追加したレイヤーへの接続を常に失う問題

Question

こんにちは、

ArcGIS for Excel がスプレッドシートに追加したレイヤーへの接続を失う問題を経験している方はいませんか？私は ArcGIS Online からの複数のレイヤーをアドイン経由で含む Excel ファイルを月に数回編集しています。これらのレイヤーのデータをフィルターや特定の列のハイライトで作業しやすくフォーマットするのに時間をかけていますが、アドインが私のタブが ArcGIS Online 由来であることを認識しないことが多く、この作業を何度もやり直さなければなりません。以下はマップウィンドウが実質的にマップウィンドウ内に GIS レイヤーがないと言っている状態（注：私のレイヤーはフィーチャーテーブルです）ですが、下の3つの青いタブはすべて以前スプレッドシートで作業した AGOL フィーチャーサービスです。この接続喪失はセッション間で起こる傾向がありますが、別のスプレッドシートではセッション中にも接続が切れることがあり、そのため Excel で行った編集が AGOL に同期されないこともありました。

同様の問題を経験された方はいらっしゃいますか？もしそうなら、この問題を防ぐためにできることはありますか？レイヤーを再度追加せずに接続を再確立する方法はありますか？

ArcGIS for Excel アドインはオンラインデータセットと連携して作業する上で画期的なツールとなる可能性がありますが、データセットへの接続が頻繁に失われるため、多くのフォーマット作業をやり直さなければならず、編集内容が同期されるかどうか確信できないことにますますフラストレーションを感じています。

何か助けていただけると大変ありがたいです。

ありがとうございます

Anthony

ShannonCardoza · Answer

@AnthonyJonesRSK Thank you for the update!

I feel like there is some data corruption going on. The inconsistency in the outcome varies which makes it hard to pinpoint a solution.

1. Are you able to reproduce one behavior repeatedly, meaning if I do step 1, 2, 3 then sync option stops appearing?

2. Also are you able to share your worksheet with me (via direct message)?

You may also call our tech support line to see if we can get you someone to assist further. I am not sure if you've contacted support services but you would need your customer number and be eligible for support. If you'd like to explore that avenue, the phone number is 1-888-377-4575.

One last test you may try is recreating a blank worksheet and run some of the workflows you currently do. If things run smoothly, the issues may be worksheet specific. Either way this will help us to know which direction to move forward.

Hope this helps...

SC

AnthonyJonesRSK · Answer

Hi @ShannonCardoza,

Thank you very much for coming back to me on this. Please find my responses to your questions below:

* Yes I can see the data layer tabs in Excel but they do not show under the layers section of the ArcGIS for Excel map despite doing so previously.
* With regards to formatting, yes, I'm simply adding a filter to my worksheet, changing column widths and highlighting some of the columns I need to edit so no changes to the actual data that would need to be synced.
* On my tabs not being recognised as from ArcGIS Online - the layers no longer show in the map window and although my tabs persist any edits to the data are not recognised so I get no notification to sync and the changes do not appear in the feature service.
* With regards to losing connection during a session what I mean by this is that I've had an occasion where I was making edits and the sync option was appearing and I was able to sync without issue. But later in the session I noticed the sync option was not appearing and then found that the layers were not showing in the map window. So I ended up with edits in my worksheet that were not able to sync to the feature service.
* I'm the only person I'm aware of this issue but I don't know if others use it regularly. I use it to manage our users as we have python scripts that run and extract user data each day so it's very useful for managing that. As far as I'm aware there is no way to re-establish the connection other than removing the tabs and adding them back in. A way to reconnect would be fantastic as re-adding the layers resets the formatting and means edits can be loss which is where the frustration comes from. Is there potentially some kind of cache that may be getting reset that results in the loss of connection?
* I'm using an ArcGIS Online account.
* Thank you for the article link I'll be sure to check that out.

Thanks

Anthony

ShannonCardoza · Answer

Good morning  @AnthonyJonesRSK,

Thank you for posting your question! I am sorry to hear you are experiencing frustration with this workflow. I do have additional questions to help clarify my understanding.

When you say, ArcGIS for Excel losing connection to layers added to the spreadsheet
- this means you can see your data in Excel but not in the TOC (as seen from your screenshot)?

When you said, I spend time formatting the data in these layers using filters and highlighting certain columns to make them easier to work.
- to confirm you are applying these edits in the Excel worksheet? Saving editing or formatting in Excel is separate then saving/editing in ArcGIS for Excel. Something like this...

Versus any edits made to the ArcGIS layer attribute data in the Excel worksheet directly update the hosted layer in ArcGIS (use Sync with ArcGIS data tool)

When you say, fails to recognize that my tabs are from ArcGIS Online.

- Can you explain this, how are the tabs failing to be recognized? By not being saved in workbook or
by not being added to the map? or both?

When you say, I've seen it lose connection during a session which has meant edits I've made in Excel will not sync to AGOL.
- This connection isn't live, meaning data has to be sync'd for it to apply and then it must be saved in Excel.

Has anyone else seen this kind of issue and if so is there anything that can be done to prevent it?
Is there a way to re-establish the connection without just adding the layers in again?
- I have not seen this as a reoccurring issue or a frequent topic of conversation but I will be on the look out for this!

Also to confirm this is an ArcGIS Online account you are using or an Enterprise account?

I also have a great article and video recording written by my colleague, it maybe helpful in seeing an example workflow, please check it out, Add and Edit ArcGIS Layer Attribute Data in an Excel Worksheet.

I know I asked a ton of follow up questions so sorry but its easy to misunderstand what you said and what I think you said 😂

Keep me posted!

SC