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?

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?

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?

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?