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.