Forum Discussion
Solved
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, ...
anmattos81 You may have accidentally saved the file as an xls rather than an xlsx.
anmattos81 You may have accidentally saved the file as an xls rather than an xlsx.
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.
