Forum Discussion
Will 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...
Hi Reuben.
I reproduced this issue in my spreadsheet and got the below result.
I've tried to convert the range B2:B4 to a table, but since the range has multi-cell array formula which is TRANSPOSE, I can't do that!
You should have a formula like this in the range you're trying to convert to a table!
If not, please attach the spreadsheet that has this issue in order to figure out what is the problem.
Regards,
Haytham
Thank you Haytham! I don't have any formula such as "transpose". I have copied page from spreadsheet here. I want to create data table in the cell range B3:AH38
Cells U31, U32, and U33 have array formulas that are different from the other formulas in the column.
You are 100% right!! It is in a hidden column (or a column somebody narrowed so as to unreadable and effectively hidden) and many people have fooled around with this spreadsheet. But you are absolutely right! Thanks very much!
Reuben Vabner
