D
DEON
I NEED MORE THAN THE ALLOWED QTY OF WORKSHEETS IN A SINGLE WORKBOOK, IS IT
POSSIBLE AND HOW( 1000)
POSSIBLE AND HOW( 1000)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
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/excel/HP051992911033.aspx
Mike
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/excel/HP051992911033.aspx
Mike
D
David Biddulph
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.
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.
D
DEON
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
virtual mem, or ram
I have tried inserting extra sheets on diff pc but the limit seams to stay
around 250
D
DEON
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)
+Worksheet and workbook specifications
Sheets in a workbook Limited by available memory (default is 3 sheets)
D
David Biddulph
Perhaps you could explain to us the respect in which you believe the
statement is incorrect?
statement is incorrect?
M
Mike H
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
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