I have a spreadsheet I put together a couple years ago that used to work great, and now is screwed up by the new dynamic, spilled array .... stuff.
The spreadsheet uses cell values in a named range, say column B, as input parameters in a variety of formulas located in cells of column C.
In the template file the first character in the formula cells is an &, so that this column can be used to populate tables for different projects, then can be replaced with = to convert them to functioning formulas.
I used this file for the first time in a while and now the use of the named range is, apparently, triggering this lovely new dynamic array SPILLED function thing.
It wants to use the formula in cell C5 to spill down results using the values in cells B5 thru B55.
None of the formulas contain dymanic spilled operator commands.
Can we not use named ranges as regular old array functions anymore?
How do I fix this?
Updated, any formula I write in the tab with the name of the named range acts as a spilled formula. LOVE IT!
Bookmarks