Forum Discussion
Solved
Dynamic arrays not working in Teams Excel
Hi, I don't know if this is something that other people are finding but my dynamic arrays don't work within Teams. If I open 'in app' they work fine but not in Teams Excel. Disappointi...
That's something else. Actually Excel in Teams is the same as Excel for web and the lates supports dynamic arrays.
Another story Excel for web has limited functionality compare to Excel desktop app. Without the file it's hard to say what exactly doesn't work. You have #N/A error, #CALC! could appear due to other errors, etc.
What happens if you share the Excel file from a Sharepoint (or OneDrive for Business) location?