Maximum Size of Excel Workbook?

Topic

New Reply

I am trying to find out what the maximum size of an excel workbook can be. I have seen where it can have a max of 255 sheets and there are only so many records can go on a sheet but I have not seen anywhere that says what the max size would be of the whole workbook…anyone have any idea???

Reply | Quote

Replies

In Excel do Help/Contents and Index
Key in Limits and froolw the trail.
This may answer some of your questions

Reply | Quote

Q264626 XL2000: Microsoft Excel 2000 Specifications

It doesn’t actually state the maximum files size, so it probably falls into the ‘Limited only by system resources’ category.

Reply | Quote

Since the largest data type a cell can contain is var length string and the size of a stringe is 10 + string length, and since the limit on a string is 2 billion characters, hypothetically, the max size of a workbook would be:
255 worksheets

Reply | Quote

So can you add code modules to a workbook with 255 sheets?

Reply | Quote

Just to clarify: the Help says the max number of DEFAULT worksheets in a workbook is 255.

You can actually add more through code – I’ve just told Excel to add 300 sheets to a book via VBA and it did so quite happily.

Jeremy

Reply | Quote