Forum Discussion

JosemaLopez's avatar
JosemaLopez
Copper Contributor
Apr 14, 2021
Solved

Excel error with spilling in frequency function

Hello, 

I am using Excel with Microsoft Office 2019 in a Windows 10 OS. 

Some days ago I remember using the frequency function without the Ctrl+Shift+Enter, and all the results spilled in a matrix all the way down. 

Nevertheless, today I tried to use it, and had to use the Ctrl+Shift+Enter functionality, as in the old versions of Excel. 

I've reinstalled and restored Office and didn't work. Also searched on the internet, and on the Excel options and didn't find nothing that could give answer to my problem.

I suspect that the recent update of my OS by Microsoft might have produced the loss of this functionality. 

I hope you can help me. 

Thanks. 

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    JosemaLopez 

    Dynamic arrays and spilling is only supported by Office 365 and probably the next Excel 2021 but never Excel 2019.

     

    • JosemaLopez's avatar
      JosemaLopez
      Copper Contributor

      Detlef_Lewin 

      Well, guess I should be wrong and that never happened in my Excel. 

      Thanks for your response. 

      Case closed. 

Resources