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...
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
