Excel - How many worksheets can you have in one workbook?
Asked By K on 20-Mar-08 07:04 PM
How many total worksheets (tabs) can you have in one workbook? Thanks
Bob Phillips replied on 20-Mar-08 07:33 PM
As many as the memory can handle if you add them via VBA.
(there is no email, no snail mail, but somewhere should be gmail in my addy)
FSt replied on 20-Mar-08 07:37 PM
in xl help type the word specifications. this will tell you the specs and
limits of your version of excel.
2007 specs and limits.
number of sheets in a workbook.....limited by available resources.
Dave Peterson replied on 20-Mar-08 07:39 PM
Lots. It depends on how much your pc's memory can handle.
Bill Sharpe replied on 21-Mar-08 12:56 PM
How many do you want?
JP replied on 23-Mar-08 12:47 AM
While researching the answer to this question I stumbled on this MS
It lists the specs and limits for charts, worksheets, etc, for XL
- Hide quoted text -
Gord Dibben replied on 21-Mar-08 05:31 PM
The maximum default number in a new workbook is 255.
After that you can add as many as you like depending upon resources as others
Gord Dibben MS Excel MVP