SOLVED

Dynamic Arrays Limit per workbook?

Copper Contributor

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.

ds100_0-1661197083100.png

Thank you

 

3 Replies

@ds100 

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.

 

NikolinoDE

I know I don't know anything (Socrates)

best response confirmed by Hans Vogelaar (MVP)
Solution
@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.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution
@NikolinoDE
This is great information. Thanks so much.

View solution in original post