maximum calculations per excel workbook?

R

RichardZ

I am wondering what the maximum number of calculation that excel can make per
workbook? Where do I look to see current number of calculations?
 
G

Gary L Brown

All depends on memory

One worksheet within a workbook has 16,777,216 cells and can therefore
theoretically have 16,777,216 formulas (depending on memory).
One workbook can have as many worksheets as you want.

To get the number of cells in a worksheet, the following VBA will give you
the total formulas in the active worksheet...

application.Range("A1:IV65536").SpecialCells(xlCellTypeFormulas).Count

HTH,
 
Top