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...
- NikolinoDE
This is great information. Thanks so much.
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.