BUG-000154577 for ArcGIS for Excel

不具合 ID 番号	BUG-000154577
送信されました	December 19, 2022
最終更新日	June 5, 2024
適用対象	ArcGIS for Excel
見つかったバージョン	2022.2
オペレーティングシステム	Windows OS
オペレーティングシステムのバージョン	11.0 64 bit
ステータス	As Designed

参考情報

This is a limitation of Excel tables. Formulas are not supported in Excel table headers, and spilled array formulas are not supported in Excel table rows. See the Excel documentation for more information: https://support.microsoft.com/en-au/office/-spill-error-table-formula-8bfa1758-1be4-42f4-a974-c4d4bc513d4b.

対処法

There are two workarounds:

To keep the formulas and convert the table to a normal cell range: After formatting as a table, go to Table Design > Tools > Convert to range.
To keep the table and convert the formulas to text or numbers: Right after adding the formulas, select the formulas, then go to Home and click the drop-down arrow next to the 'Paste' clipboard icon and select Paste as Values. After this, go to Home. In the Styles gtoup, select Format as Table.