Excel help files state that you can insert as many sheets as your RAM can
handle.

Perhaps you can use named ranges instead of separating in sheets

"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?