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 very much. I did search for the first bracket "{" using FIND but it said there are none. I will try again but it may again tell me no such bracket in table area. Thanks for your help.
Reuben
Tried again.Cannot find any brackets. Also, if you try to "sort and filter" (custom), it will not do that either because there is supposedly an array in the range I want to sort and filter.
Thank you, Reuben