Forum Discussion
Dynamic Arrays Limit per workbook?
Hi All,
How many dynamic arrays are too many?
I have a 5MB file with many tabs, most of which are reports running dynamic arrays (primary source of data is a several thousand row table).
Lately I've been spending a lot of time staring at a spin wheel. Curious if its a product of too many calculations or something completely separate.
I'm running Windows 10 Pro w Microsoft 365 Apps for business, excel Version 2207 (Build 15427.20210)
This is what shows up in Task Manager.
Thank you
- NikolinoDE
This is great information. Thanks so much.
3 Replies
Dynamic array formulas and spilled array behavior
As beautiful and functional as the new array functions are, there are a few things to watch out for.
If the new functions are not subsequently delivered in "older" Excel versions in the data exchange, the data exchange between the Excel versions will become even more complex.
It is also recommended to determine or restrict the cell area in order to save calculation time and computer resources.
Additional Infos:
Excel specifications and limits
Description of the limitations for working with arrays in Excel
Guidelines and examples of array formulas
Hope I could help you with these information / links.
I know I don't know anything (Socrates)
- NikolinoDE
This is great information. Thanks so much.- I am glad that I could help you with your project.
I wish you continued success with Excel.
