Hi CTN-

Textbook answer is 255 sheets. If you cannot insert more than 30 it may very
well be the result of insufficient RAM. Which version of Excel, Windows and
what happens when you try to insert more?

Regards |:)

"CTN" wrote:

How many worksheets can you have in one workbook. Right now we're doing a
file for all weeks of the year and we've got 30 in it, but it won't allow us
to insert any more. Any way around this?