How many worksheets in a workbook

How many worksheets can you have in any one Workbook??? (Excel 97)

Cheers,

Stu
scottsaAsked:
Who is Participating?
 
Anne TroyConnect With a Mentor East Coast ManagerCommented:
Right from the help file:

Program workspace specifications

Feature      Specification
Maximum number of custom toolbars in a workbook      Limited by available memory
Maximum number of custom toolbar buttons      Limited by available memory
Maximum number of open workbooks      Limited by available memory and system resources
Maximum worksheet size       65,536 rows by 256 columns
Column width      0 (zero) to 255 characters
Row height       0 to 409 points
Maximum length of cell contents (text)       32,000 characters
Maximum length of formula contents      1,024 characters
Maximum number of sheets in a workbook      Limited by available memory (default number of sheets is 3; the maximum number of sheets in a default workbook is 255)
0
 
jbeamanCommented:
Couldnt find any info about the maximum number of worksheets, but did find an interesting article about the cell table and heap space limits:
http://support.microsoft.com/support/kb/articles/Q99/3/45.ASP?LN=EN-US&SD=gn&FR=0

hth,
jbeaman
0
 
scottsaAuthor Commented:
Thanks for your help Dreamboat!! Much appreciated.

Stu
0
 
Anne TroyEast Coast ManagerCommented:
Anytime...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.