ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sheets In a Workbook (https://www.excelbanter.com/excel-discussion-misc-queries/173009-sheets-workbook.html)

Maze

Sheets In a Workbook
 
How many Sheets are there in a Work Book?

Tyro[_2_]

Sheets In a Workbook
 
Excel 2007 puts no limit on the number of worksheets in a workbook.

Tyro



"Maze" wrote in message
...
How many Sheets are there in a Work Book?




Maze

Sheets In a Workbook
 
On Jan 14, 7:58*pm, "Tyro" wrote:
Excel 2007 puts no limit on the number of worksheets in a workbook.

Tyro

"Maze" wrote in message

...



How many Sheets are there in a Work Book?- Hide quoted text -


- Show quoted text -


How about in Excel 2003?

RagDyeR

Sheets In a Workbook
 
Just as a topic of conversation, since I doubt anyone would go to these
lengths:

Max sheets is 5,447


As tested by Dana in XL07,
And verified by Harlan in XL03.


Attempting to insert the 5,448th caused both versions to crash!

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tyro" wrote in message
...
Excel 2007 puts no limit on the number of worksheets in a workbook.

Tyro



"Maze" wrote in message
...
How many Sheets are there in a Work Book?






FSt1

Sheets In a Workbook
 
hi
in xl help type the word specifications. this will give you the specs and
limits of your version of excel.
number of sheets in 2003. limited by available resources ie memory, hard
drive ect.
default is 3.
regards
FSt1

"Maze" wrote:

On Jan 14, 7:58 pm, "Tyro" wrote:
Excel 2007 puts no limit on the number of worksheets in a workbook.

Tyro

"Maze" wrote in message

...



How many Sheets are there in a Work Book?- Hide quoted text -


- Show quoted text -


How about in Excel 2003?


Maze

Sheets In a Workbook
 
On Jan 14, 8:22*pm, FSt1 wrote:
hi
in xl help type the word specifications. this will give you the specs and
limits of your version of excel.
number of sheets in 2003. limited by available resources ie memory, hard
drive ect.
default is 3.
regards
FSt1



"Maze" wrote:
On Jan 14, 7:58 pm, "Tyro" wrote:
Excel 2007 puts no limit on the number of worksheets in a workbook.


Tyro


"Maze" wrote in message


....


How many Sheets are there in a Work Book?- Hide quoted text -


- Show quoted text -


How about in Excel 2003?- Hide quoted text -


- Show quoted text -


How about on Excel 2000?

FSt1

Sheets In a Workbook
 
hi
the same i think.

Regards
FSt1

"Maze" wrote:

On Jan 14, 8:22 pm, FSt1 wrote:
hi
in xl help type the word specifications. this will give you the specs and
limits of your version of excel.
number of sheets in 2003. limited by available resources ie memory, hard
drive ect.
default is 3.
regards
FSt1



"Maze" wrote:
On Jan 14, 7:58 pm, "Tyro" wrote:
Excel 2007 puts no limit on the number of worksheets in a workbook.


Tyro


"Maze" wrote in message


....


How many Sheets are there in a Work Book?- Hide quoted text -


- Show quoted text -


How about in Excel 2003?- Hide quoted text -


- Show quoted text -


How about on Excel 2000?



All times are GMT +1. The time now is 12:44 PM.

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