#SPILL! error! Really, are you sure?

[Sakuragaoka2001]

I have found a problem with Excel which looks like a bug to me, but I'd like to hear an expert opinion. I have attached 2 JPEG's. My Excel version is Microsoft® Excel® for Microsoft 365 MSO (Version 2207 Build 16.0.15427.20182) 64-bi on Windows 10.

I have a 13x3 integer RANDARRAY(), in cells C3:E15. As you certainly know RANDARRAY() is a volatile function, and please note that I am using manual recalculation.

There is no hidden data or formulas in the blank cells!

Re the first JPEG: sometimes (maybe 1 out of 10 times) after pressing F9 to recalculate the sheet, I get a #SPILL! error which to me makes no sense.

Secondly, if then I click into the formula bar and press return, the result is calculated correctly without calling the RANDARRAY() function again. which proves that it _is_ possible to calculate the FILTER() function without a #SPILL! error:

Doesn't this look like an Excel bug? Could be a timing error in the calculation engine, maybe...

[#2 · Accepted solution]

@Sakuragaoka2001 

https://www.youtube.com/watch?v=iaJv6E0GRC4

[#3]

Thanks Detlef. Wondering my Microsoft don't fix this problem. PS: here's the link to the Microsoft article mentioned in the video: https://support.microsoft.com/en-us/office/-spill-volatile-size-05aad07c-947e-4c9b-bd6f-7b1f8ae6a7dc...