ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   number of worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/250100-number-worksheets.html)

Neia

number of worksheets
 
How many worksheets a workbook may have?

trip_to_tokyo[_3_]

number of worksheets
 
In EXCEL 2007, according to MS documentation:-

"Limited by available memory (default is 3 sheets)"

Please hit Yes if my comments have helped.

Thanks.

"Neia" wrote:

How many worksheets a workbook may have?


Dave Peterson

number of worksheets
 
Limited by your pc's memory.

Neia wrote:

How many worksheets a workbook may have?


--

Dave Peterson

Eduardo

number of worksheets
 
Hi,
As many as your memory can handle

"Neia" wrote:

How many worksheets a workbook may have?


Don Guillett

number of worksheets
 
Limited by memory

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Neia" wrote in message
...
How many worksheets a workbook may have?



Jim Thomlinson

number of worksheets
 
While the number of sheets you can have is limited only by memory, the number
of sheets that you should have is limited by practicallity. I will guarantee
you that you will hit your practical limit long before you hit the memory
limit.
--
HTH...

Jim Thomlinson


"Neia" wrote:

How many worksheets a workbook may have?


Gord Dibben

number of worksheets
 
One more note....................

The maximum number of default sheets for a new workbook is 255

You can add more after the workbook is open............depending upon memory
as others have pointed out.


Gord Dibben MS Excel MVP

On Fri, 4 Dec 2009 06:14:01 -0800, Neia
wrote:

How many worksheets a workbook may have?




All times are GMT +1. The time now is 10:06 PM.

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