Max. sheets in workbook?

khickey · Apr 25th, 2002, 04:14 PM

Does anyone know the maximum number of sheets a workbook can contain? (Excel 2000)

Cheers

Jack in the UK · Apr 25th, 2002, 04:17 PM

this has now real limit bat will crash if to many that you pc cant hadle.

all down to resorce allocation what is counter balanced but OP system v's and version of Excel applications running and the power resources the pc has.

NT Technoligies willperforme best as they can counter the didty memory issues in superior mannmo rto domestic windows..

just to keep it simple ill stop there let me know if you need more

Jay Petrulis · Apr 25th, 2002, 04:19 PM

Hi,

This is limited by the amount of available memory. I think the maximum number if sheets in a default workbook is 255.

You can keep adding sheets until your computer quits.

Jay

khickey · Apr 25th, 2002, 04:22 PM

Thanks guys. I am running Win2000 and have heaps of memory.... I'll just keep adding sheets and see what happens!!!

Jack in the UK · Apr 25th, 2002, 04:31 PM

Win 200 nice if excel 2000 or poss XP, i would go good for hundreds, but REMENMBER back up always so no crying later

if sheets are light more is nasty heavy and book size over 5mb be careful... 10mb NASTY....

just some points... i always keep excel light and good looking after all she fancys me if im good to her, and im ugly!

Jay Petrulis · Apr 25th, 2002, 05:00 PM

Hi,

Try this and keep doing it until Excel crashes, if you want a fast way to test your system

Sub New_Sheets()
Dim intNumber As Integer, Counter As Integer
intNumber = _
Application.InputBox("Create how many sheets?", "Number of new sheets", "300")

Application.ScreenUpdating = False
For Counter = 1 To intNumber
Worksheets.Add
Next
Application.ScreenUpdating = True
End Sub

Apr 25th, 2002, 04:17 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	this has now real limit bat will crash if to many that you pc cant hadle. all down to resorce allocation what is counter balanced but OP system v's and version of Excel applications running and the power resources the pc has. NT Technoligies willperforme best as they can counter the didty memory issues in superior mannmo rto domestic windows.. just to keep it simple ill stop there let me know if you need more __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 25th, 2002, 04:31 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Win 200 nice if excel 2000 or poss XP, i would go good for hundreds, but REMENMBER back up always so no crying later if sheets are light more is nasty heavy and book size over 5mb be careful... 10mb NASTY.... just some points... i always keep excel light and good looking after all she fancys me if im good to her, and im ugly! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 04:14 PM	#1
khickey New Member Join Date: Apr 2002 Posts: 16	Does anyone know the maximum number of sheets a workbook can contain? (Excel 2000) Cheers

Apr 25th, 2002, 04:19 PM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, This is limited by the amount of available memory. I think the maximum number if sheets in a default workbook is 255. You can keep adding sheets until your computer quits. Jay

Apr 25th, 2002, 04:22 PM	#4
khickey New Member Join Date: Apr 2002 Posts: 16	Thanks guys. I am running Win2000 and have heaps of memory.... I'll just keep adding sheets and see what happens!!!

Apr 25th, 2002, 05:00 PM	#6
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Try this and keep doing it until Excel crashes, if you want a fast way to test your system Sub New_Sheets() Dim intNumber As Integer, Counter As Integer intNumber = _ Application.InputBox("Create how many sheets?", "Number of new sheets", "300") Application.ScreenUpdating = False For Counter = 1 To intNumber Worksheets.Add Next Application.ScreenUpdating = True End Sub