Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many worksheets can I add on a workbook for Excel XP
I am working on a workbook and I will be adding maybe 200 worksheets, will
that be possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many worksheets can I add on a workbook for Excel XP
The maximum number of worksheets is 255. If you are planning on doing this
at one time a quick way to add a lot of worksheets is click ToolsOptionsGeneral and select how many sheets you want in the new notebook. Open a new book and then chage it back to a more reasonable number. I hope that helps. "Elda" wrote: I am working on a workbook and I will be adding maybe 200 worksheets, will that be possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many worksheets can I add on a workbook for Excel XP
No, the maximum number of worksheets is limited by available memory. The
maximum number of worksheets you can instruct XL to open a new workbook with is 255. There's a distnct difference there, though. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Chrisinct" wrote: The maximum number of worksheets is 255. If you are planning on doing this at one time a quick way to add a lot of worksheets is click ToolsOptionsGeneral and select how many sheets you want in the new notebook. Open a new book and then chage it back to a more reasonable number. I hope that helps. "Elda" wrote: I am working on a workbook and I will be adding maybe 200 worksheets, will that be possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many worksheets can I add on a workbook for Excel XP
You can add as many as you want until you run out of memory.
The maximum number of default sheets in a new workbook is 255 but you can add more later if you can get away with it. Gord Dibben MS Excel MVP On Tue, 3 Apr 2007 10:04:11 -0700, Elda wrote: I am working on a workbook and I will be adding maybe 200 worksheets, will that be possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Worksheets within a Workbook | Excel Worksheet Functions | |||
Excel should apply names in all worksheets of a workbook | Excel Discussion (Misc queries) | |||
Excel should let its worksheets be arranged (tiled) in a workbook | Excel Worksheet Functions | |||
Slow opening Excel Workbook with over 50 Worksheets | Excel Discussion (Misc queries) | |||
updating excel worksheets to another workbook | Excel Worksheet Functions |