SOLVED

Excel not producing dynamic array output

%3CLINGO-SUB%20id%3D%22lingo-sub-2773686%22%20slang%3D%22en-US%22%3EExcel%20not%20producing%20dynamic%20array%20output%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2773686%22%20slang%3D%22en-US%22%3E%3CP%3EI%20teach%20students%20using%20basic%20Excel.%26nbsp%3B%20For%20the%20LINEST()%20function%2C%20I%20have%20switched%20over%20to%20using%20the%20dynamic%20array%20style%3A%20enter%20in%20one%20cell%2C%20no%20CSE%2C%20let%20the%20results%20spill.%3C%2FP%3E%3CP%3EI%20have%20a%20student%20using%20the%20exact%20same%20version%20as%20myself%20(16.53%20(21091200)%20on%20macOS)%2C%20but%20when%20he%20enters%20LINEST%20in%20this%20fashion%2C%20he%20only%20gets%20a%20single%20number.%26nbsp%3B%20No%20spilling%20happens.%26nbsp%3B%20He%20is%20not%20using%20Cntrl-Shft-Enter%20(I%20watched).%26nbsp%3B%20Why%20would%20this%20be%20happening%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2773686%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2773995%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20producing%20dynamic%20array%20output%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2773995%22%20slang%3D%22en-US%22%3EI%20know%20when%20they%20release%20updates%20even%20if%20you%20have%20the%20same%20version%20you%20may%20not%20have%20the%20same%20features%20enabled%20based%20on%20you%20subscription%20and%20their%20roll%20out.%20But%20dynamic%20arrays%20has%20now%20been%20released%20long%20enough%20I%20would%20not%20expect%20that%20to%20be%20the%20problem.%20That%20said%2C%20the%20easiest%20thing%20to%20check%20is%20if%20the%20students%20version%20recognizes%20DA%20formulas%20like%20FILTER()%20and%20UNIQUE().%20Also%20what%20if%20they%20just%20enter%20a%20simple%20formula%20with%20spill%20over%20like%20%3DB1%3AB3%20%2C%20does%20it%20spill%20over%20then%3F%3CBR%20%2F%3EIf%20that%20all%20works%20then%20if%20you%20save%20your%20file%20and%20give%20that%20file%20to%20them%20to%20open%20will%20it%20work%3F%3CBR%20%2F%3EI%20hope%20some%20of%20these%20steps%20can%20narrow%20down%20the%20potential%20cause.%3C%2FLINGO-BODY%3E
New Contributor

I teach students using basic Excel.  For the LINEST() function, I have switched over to using the dynamic array style: enter in one cell, no CSE, let the results spill.

I have a student using the exact same version as myself (16.53 (21091200) on macOS), but when he enters LINEST in this fashion, he only gets a single number.  No spilling happens.  He is not using Cntrl-Shft-Enter (I watched).  Why would this be happening?

2 Replies
I know when they release updates even if you have the same version you may not have the same features enabled based on you subscription and their roll out. But dynamic arrays has now been released long enough I would not expect that to be the problem. That said, the easiest thing to check is if the students version recognizes DA formulas like FILTER() and UNIQUE(). Also what if they just enter a simple formula with spill over like =B1:B3 , does it spill over then?
If that all works then if you save your file and give that file to them to open will it work?
I hope some of these steps can narrow down the potential cause.
best response confirmed by James6M (New Contributor)
Solution

@mtarlerThanks much for your troubleshooting help.  It turns out that Excel had automatically added a "@" to the beginning of the formula.  I'm not 100% sure what caused that.  But of course removing it returned the expected results.