Max number of sheets in a workbook

[ChemistB]

Quick question,
What's the maximum number of worksheets allowed within a workbook? Is it different for Excel 2000, 2003, Etc?

Thanks

ChemistB

[oldchippy]

The maximum number of worksheets in a workbook depends on your computer's memory. The default workbook can have up to 255 worksheets.

[Trebor76]

Hi there,

I've always known the maximum to be 255 (for whatever version), though I've never seen a workbook with anywhere near this number of tabs.

Cheers,

Robert

HTH

[ChemistB]

Thanks to both of you.

I am looking at combining data from a number of different workbooks into a single one and wanted to know where the cutoff would be.

ChemistB

[Paul]

I'm sure Microsoft.com could supply any definitive answer, but I'll say this.. I used some vba code last week to create worksheets based on date, and had no problem creating well over 1000 worksheets in one workbook for the next 3-5 years worth of dates.

This would lead me to believe the max limit is available memory. With that many sheets you'd definitely need a good amount of memory if there was data in each of them.

I use Excel 2003, for reference.

[lsmft]

I'm sure Microsoft.com could supply any definitive answer, but I'll say this.. I used some vba code last week to create worksheets based on date, and had no problem creating well over 1000 worksheets in one workbook for the next 3-5 years worth of dates.

This would lead me to believe the max limit is available memory. With that many sheets you'd definitely need a good amount of memory if there was data in each of them.

I use Excel 2003, for reference.

My old computer is so slow, I named it Ruthie after Festus Hagen's mule on Gunsmoke.
I now have 256 mb memory but earlier I had 128. All it could handle then was 28 worksheets.