What is the max number of sheets I can have in a wookbook?

[strayerld]

--
LDStrayer

 

[Don Guillett]

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Victor Delta]

LDStrayer

The number is limited only by available memory and system resources - see
http://office.microsoft.com/en-us/excel/HP051992911033.aspx

The max number in a new workbook can be set to 255 but more can then be
added.

If you google the topic you'll find mentions of spreadsheets with up to
several thousand sheets. Of course, you might have the memory to open such a
workbook but it could crash others' pcs.

V

 

[Shane Devenshire]

Microsoft says this is limited by memory, but I have crashed Excel at around
7000 sheet but with plenty of memory to spare.

But who would want 7000 sheets in one workbook?

No need to Goggle, its in the help system under specifications.

 

[Jim Cone]

I think the OP should go with Don's answer.
It is the best match to the question.
--
Jim Cone
Portland, Oregon USA



"(e-mail address removed)" <[email protected]>
wrote in message