I NEED MORE THAN THE ALLOWED QTY OF WORKSHEETS IN A SINGLE WORKBOOK, IS IT
POSSIBLE AND HOW( 1000)

Hi,

The number of worksheets in a workbook is limited by the capacity of your PC
and not Excel so the answer is upgrade the memory.

Have a look here

http://office.microsoft.com/en-us/ex...992911033.aspx

Mike

"DEON" wrote:

I NEED MORE THAN THE ALLOWED QTY OF WORKSHEETS IN A SINGLE WORKBOOK, IS IT
POSSIBLE AND HOW( 1000)

In general for specification limits, where this is an allowed quantity you
are allowed up to the allowed quantity. Beyond the allowed quantity is not
allowed. :-(
For more details, look at "specification and limits" in Excel help.

And your caps lock key is broken.
--
David Biddulph

"DEON" wrote in message
...
I NEED MORE THAN THE ALLOWED QTY OF WORKSHEETS IN A SINGLE WORKBOOK, IS IT
POSSIBLE AND HOW( 1000)

Thanks, but when you talking about memory are you refering to hard drive mem,
virtual mem, or ram
I have tried inserting extra sheets on diff pc but the limit seams to stay
around 250

"Mike H" wrote:

Hi,

The number of worksheets in a workbook is limited by the capacity of your PC
and not Excel so the answer is upgrade the memory.

Have a look here

http://office.microsoft.com/en-us/ex...992911033.aspx

Mike

"DEON" wrote:

I NEED MORE THAN THE ALLOWED QTY OF WORKSHEETS IN A SINGLE WORKBOOK, IS IT
POSSIBLE AND HOW( 1000)

THEN THE FOLOWING STATEMENT ON THE SYSTEM IS INCORRECT
+Worksheet and workbook specifications
Sheets in a workbook Limited by available memory (default is 3 sheets)


"David Biddulph" wrote:

In general for specification limits, where this is an allowed quantity you
are allowed up to the allowed quantity. Beyond the allowed quantity is not
allowed. :-(
For more details, look at "specification and limits" in Excel help.

And your caps lock key is broken.
--
David Biddulph

"DEON" wrote in message
...
I NEED MORE THAN THE ALLOWED QTY OF WORKSHEETS IN A SINGLE WORKBOOK, IS IT
POSSIBLE AND HOW( 1000)

Perhaps you could explain to us the respect in which you believe the
statement is incorrect?
--
David Biddulph

"DEON" wrote in message
...

THEN THE FOLOWING STATEMENT ON THE SYSTEM IS INCORRECT
+Worksheet and workbook specifications
Sheets in a workbook Limited by available memory (default is 3 sheets)


"David Biddulph" wrote:

In general for specification limits, where this is an allowed quantity
you
are allowed up to the allowed quantity. Beyond the allowed quantity is
not
allowed. :-(
For more details, look at "specification and limits" in Excel help.

And your caps lock key is broken.
--
David Biddulph

"DEON" wrote in message
...
I NEED MORE THAN THE ALLOWED QTY OF WORKSHEETS IN A SINGLE WORKBOOK, IS
IT
POSSIBLE AND HOW( 1000)

The statement in the specification limts is correct you can have as many
sheets as the memory (RAM) on you computer can handle.

I ran this simple loop

do
worksheets.add
loop

I get bored after 4000 sheets and ended the loop. I have 2 gig of RAM but
you need to be aware that in my very unscientific test, all of my sheets we
empty so for sheets of data the amount I could add would be less.

Mike

"DEON" wrote:


THEN THE FOLOWING STATEMENT ON THE SYSTEM IS INCORRECT
+Worksheet and workbook specifications
Sheets in a workbook Limited by available memory (default is 3 sheets)


"David Biddulph" wrote:

In general for specification limits, where this is an allowed quantity you
are allowed up to the allowed quantity. Beyond the allowed quantity is not
allowed. :-(
For more details, look at "specification and limits" in Excel help.

And your caps lock key is broken.
--
David Biddulph

"DEON" wrote in message
...
I NEED MORE THAN THE ALLOWED QTY OF WORKSHEETS IN A SINGLE WORKBOOK, IS IT
POSSIBLE AND HOW( 1000)