Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
maximum calculations per excel workbook?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
maximum calculations per excel workbook?
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(xlCel lTypeFormulas).Count HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "RichardZ" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
what is the maximum columns I can have on an excel workbook | Excel Worksheet Functions | |||
copy a sheet in same workbook temporary block excel | Excel Worksheet Functions |