Excel: Max # of worksheets?

[Mollox]

Is there a limit for the number of separate worksheets you can have in a workbook?

Trying to find a platform for something and I reckon its gonna need 300-500 worksheets

[sidicks]

As far as I can remember, it used to be 256 (=2^8 !!), unless newer versions of excel can handle more.

Sidicks

[scooby_simon]

newer Versions don't have a limit (in theory) from the help :

[ QUOTE ]

Feature Maximum limit

Open workbooks Limited by available memory and system resources

Worksheet size 65,536 rows by 256 columns

Column width 255 characters

Row height 409 points

Page breaks 1000 horizontal and vertical

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

Sheets in a workbook Limited by available memory (default is 3 sheets)

Colors in a workbook 56

Cell styles in a workbook 4,000

Named views in a workbook Limited by available memory

Custom number formats Limited by available memory

Names in a workbook Limited by available memory

Windows in a workbook Limited by system resources

Panes in a window 4

Linked sheets Limited by available memory

Scenarios Limited by available memory; a summary report shows only the first 251 scenarios

Changing cells in a scenario 32

Adjustable cells in Solver 200

Custom functions Limited by available memory

Zoom range 10 percent to 400 percent

Reports Limited by available memory

Sort references 3 in a single sort; unlimited when using sequential sorts

Undo levels 16

Fields in a data form 32

Custom toolbars in a workbook Limited by available memory

Custom toolbar buttons Limited by available memory

[/ QUOTE ]

[Mollox]

Ta - did actually google this just after I'd posted

I think it depends ultimately on available memory.

Nice tip though, if you want a lot of worksheets you can use Tools > Options > General to set the default # of worksheets up to 255 - from then on just insert new ones