Is there really a 255 worksheet limit in Excel?

This topic has 1 reply, 1 voice, and was last updated 1 day, 8 hours ago by administrator@dailyexcel.net.

Viewing 1 reply thread

Author

Posts
- September 24, 2025 at 15:02 #10828 Reply
  
  Merz
  Guest
  
  I need to put into production a workbook with 400+ worksheets, which I can create, but I’m worried about compatibility issues as several places online mention this 255 number.
- September 24, 2025 at 16:20 #10829 Reply
  administrator@dailyexcel.net
  Keymaster
  Excel does not limit the number of worksheets!
  
  For example, you can create 1000 worksheets using the following VBA code:
```
Sub AddSheets()

Dim n As Integer

For n = 2 To 1000

Sheets.Add(After:=Sheets("Sheet" & n - 1 )).Name = "Sheet" & n

Next n

End Sub
```
  This number probably comes from the limits imposed by other (legacy) software, i.e. Lotus, OpenOffice etc.
Author

Posts

Viewing 1 reply thread