Bug
When users format functions into a table, the entries of the function builder are removed or converted to static text in ArcGIS for Excel.
| Bug ID Number | BUG-000154577 |
|---|---|
| Submitted | December 19, 2022 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS for Excel |
| Version found | 2022.2 |
| Operating System | Windows OS |
| Operating System Version | 11.0 64 bit |
| Status | As Designed |
Additional Information
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.Workaround
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.
Steps to Reproduce
Bug ID: BUG-000154577
Software:
- ArcGIS for Excel
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App