ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How many worksheets can be inserted in one workbook? (https://www.excelbanter.com/new-users-excel/186964-how-many-worksheets-can-inserted-one-workbook.html)

Bobby

How many worksheets can be inserted in one workbook?
 
I have just started using MS-Excel. I was wondering what is the maximum
number of worksheets that can be inserted in 1 MS-Excel Workbook?

T. Valko

How many worksheets can be inserted in one workbook?
 
If I remember correctly, I've seen folks report that they're been able to
insert upwards of 1000 sheets (as a test).

For practical purposes you're limited by the amount of memory your system
has.

Search Excel help for "specifications and limits". It says:
Sheets in a workbook - Limited by available memory (default is 3 sheets)


--
Biff
Microsoft Excel MVP


"Bobby" wrote in message
...
I have just started using MS-Excel. I was wondering what is the maximum
number of worksheets that can be inserted in 1 MS-Excel Workbook?





All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com