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...
You'll need to look for an array formula. You can tell that a formula is an array formula when it is enclosed in { }
BobOrrell hi bob, I got the same issue. And the formula is enclosed in {} . Is there any way to create a table with this?
- Not to my knowledge. if the formula has {} surrounding it, you cannot put that formula in a table.
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.
ReubenTried 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.
