BUG-000154577 for ArcGIS for Excel

Número de ID do Erro	BUG-000154577
Enviado	December 19, 2022
Última Modificação	June 5, 2024
Aplica-se à	ArcGIS for Excel
Versão encontrada	2022.2
Sistema Operacional	Windows OS
Versão do Sistema Operacional	11.0 64 bit
Status	As Designed

Informações Adicionais

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.

Solução Provisória

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.