practical limit on number of worksheets per workbook?
Posted by davido on December 12, 2000 1:03 PM
I am designing an industrial application that could have between 50 and 100 worksheets when it is completed. Does anyone know the answers to the following questions.
Does Excel have a limit on number of worksheets in a workbook before it tends to crash? become unstable? slow performance dramatically? any other concerns?
Is there a file size (MB) limit that should be adherred to?
Assume a machine speed of Pentium 75 or higher. 16 to 32 mb of ram minimum.
Thanks...
David
davido@wctatel.net
Posted by Greg on December 12, 2000 3:22 PM
Response: A friend had a financial spreadsheet that had 22 pages and many links between those sheets and it ran very slow. It took up about 2mb of space, which doesn't matter if you aren't putting it on a floppy disk. In general I think you will have a very slow spreadsheet if it has 50 to 100 sheets. You get better performance the less sheets you use. The friend example: he was able to decrease the size and increase the speed by putting most of the information on one sheet.
Hope that helps.
Posted by Colin Fisher on December 21, 2000 4:08 PM
From my own experience, I find that Excel begins
to get buggy at around 100 worksheets per
workbook. This is using several different kinds
of computers, probably the approximate computer
I used was about a Pentium 150.
