Forum Discussion
Spill ranges turn into arrays after closing the file
Hello all,
I have written some spill formulas in a workbook and they work very fine. I'll give an example:
=SORT(UNIQUE(FPL[Area]))
However, after closing and opening the workbook again, all my spill formulas turn into arrays and I lose the references do the data table, that turn into ranges.
{=SORT(UNIQUE('Focal Points List'!$D$2:$D$986))}
After this the spill ranges stop working correctly and I lose the readability of having the column names in the formulas.
Any clue on what is happening?
I'm using Excel 365 for Enterprises version 2202.
Regards,
anmattos81 You may have accidentally saved the file as an xls rather than an xlsx.
2 Replies
- Riny_van_EekelenPlatinum Contributor
anmattos81 You may have accidentally saved the file as an xls rather than an xlsx.
- anmattos81Copper Contributor
Riny_van_EekelenThank you very much! You are correct. I was working on an old file and have not realized that. In some sense I feel a little dumb now, but at the same time happy that the solution was simple.