Forum Discussion
Deleted
Oct 12, 2018Will not create data table because excel says there is an array in the proposed data table area.
Hi. I have a spreadsheet with an area that I want to convert to a data table. Excel comes back and says "multi-cell array formulas are not allowed in tables." So I cannot create the data table. I g...
Haritha_Mekkatt
Jun 28, 2024Copper Contributor
BobOrrell hi bob, I got the same issue. And the formula is enclosed in {} . Is there any way to create a table with this?
BobOrrell
Oct 01, 2024Iron Contributor
Not to my knowledge. if the formula has {} surrounding it, you cannot put that formula in a table.