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
Find will not work. You will have to select the cell, and you can see the brackets in the formula bar. You can click Show Formulas on the Formulas tab to make it easier to see which cells have formulas in them, but you will still need to click on each cell to see the brackets.
