How many worksheets can you have in one workbook?

  • Thread starter Thread starter KG
  • Start date Start date
As many as the memory can handle if you add them via VBA.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
The maximum default number in a new workbook is 255.

After that you can add as many as you like depending upon resources as others
have mentioned.


Gord Dibben MS Excel MVP
 
You are the biggest idiot ive ever seen in my entired god damn life. I went way the hell past 255. Get your facts in order before you start acting all smart and PISS. You little dumbbutt!



Gord Dibben wrote:

The maximum default number in a new workbook is 255.
21-Mar-08

The maximum default number in a new workbook is 255

After that you can add as many as you like depending upon resources as other
have mentioned

Gord Dibben MS Excel MVP

Previous Posts In This Thread:

How many worksheets can you have in one workbook?
How many total worksheets (tabs) can you have in one workbook? Thanks

As many as the memory can handle if you add them via VBA.
As many as the memory can handle if you add them via VBA

-
HT

Bo

(there is no email, no snail mail, but somewhere should be gmail in my addy)

hiin xl help type the word specifications.
h
in xl help type the word specifications. this will tell you the specs and
limits of your version of excel
2007 specs and limits
http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH10103062103

number of sheets in a workbook.....limited by available resources

Regard
FSt

:

Lots. It depends on how much your pc's memory can handle.
Lots. It depends on how much your pc's memory can handle

KG wrote

-

Dave Peterson

Re: How many worksheets can you have in one workbook?
KG wrote

How many do you want

Bill

The maximum default number in a new workbook is 255.
The maximum default number in a new workbook is 255

After that you can add as many as you like depending upon resources as other
have mentioned

Gord Dibben MS Excel MVP

While researching the answer to this question I stumbled on this
While researching the answer to this question I stumbled on this M
site

http://office.microsoft.com/en-us/excel/HP051992911033.asp

It lists the specs and limits for charts, worksheets, etc, for X
2003

HTH
J


- Hide quoted text -

a lot
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET: Using SQLite with Enterprise Library 3.1
http://www.eggheadcafe.com/tutorial...41c-f4dadf9b7127/aspnet-using-sqlite-wit.aspx
 
watch your fcking language you mother fcking batard dck licking fat fck of a douch go eat some gouche chees you stupid dick neck >:(



sam and jake currin and hill wrote:

RETART!!
26-Jan-10

You are the biggest idiot ive ever seen in my entired god damn life. I went way the hell past 255. Get your facts in order before you start acting all smart and PISS. You little dumbbutt!

Previous Posts In This Thread:

How many worksheets can you have in one workbook?
How many total worksheets (tabs) can you have in one workbook? Thanks

As many as the memory can handle if you add them via VBA.
As many as the memory can handle if you add them via VBA.

--
HTH

Bob

(there is no email, no snail mail, but somewhere should be gmail in my addy)

hiin xl help type the word specifications.
hi
in xl help type the word specifications. this will tell you the specs and
limits of your version of excel.
2007 specs and limits.
http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033

number of sheets in a workbook.....limited by available resources.

Regards
FSt1

:

Lots. It depends on how much your pc's memory can handle.
Lots. It depends on how much your pc's memory can handle.

KG wrote:

--

Dave Peterson

Re: How many worksheets can you have in one workbook?
KG wrote:

How many do you want?

Bill

The maximum default number in a new workbook is 255.
The maximum default number in a new workbook is 255.

After that you can add as many as you like depending upon resources as others
have mentioned.


Gord Dibben MS Excel MVP

While researching the answer to this question I stumbled on this
While researching the answer to this question I stumbled on this MS
site:

http://office.microsoft.com/en-us/excel/HP051992911033.aspx

It lists the specs and limits for charts, worksheets, etc, for XL
2003.


HTH,
JP

)
- Hide quoted text -

a lot
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

RETART!!
You are the biggest idiot ive ever seen in my entired god damn life. I went way the hell past 255. Get your facts in order before you start acting all smart and PISS. You little dumbbutt!


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Datagrid as ComboBox Dropdown Part 2
http://www.eggheadcafe.com/tutorial...96-e24127040bbf/wpf-datagrid-as-combobox.aspx
 
im going to give you the biggest fcking nipple twister ever.....



sam and jake currin and hill wrote:

RETART!!
26-Jan-10

You are the biggest idiot ive ever seen in my entired god damn life. I went way the hell past 255. Get your facts in order before you start acting all smart and PISS. You little dumbbutt!

Previous Posts In This Thread:

How many worksheets can you have in one workbook?
How many total worksheets (tabs) can you have in one workbook? Thanks

As many as the memory can handle if you add them via VBA.
As many as the memory can handle if you add them via VBA

-
HT

Bo

(there is no email, no snail mail, but somewhere should be gmail in my addy)

hiin xl help type the word specifications.
h
in xl help type the word specifications. this will tell you the specs and
limits of your version of excel
2007 specs and limits
http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH10103062103

number of sheets in a workbook.....limited by available resources

Regard
FSt

:

Lots. It depends on how much your pc's memory can handle.
Lots. It depends on how much your pc's memory can handle

KG wrote

-

Dave Peterson

Re: How many worksheets can you have in one workbook?
KG wrote

How many do you want

Bill

The maximum default number in a new workbook is 255.
The maximum default number in a new workbook is 255

After that you can add as many as you like depending upon resources as other
have mentioned

Gord Dibben MS Excel MVP

While researching the answer to this question I stumbled on this
While researching the answer to this question I stumbled on this M
site

http://office.microsoft.com/en-us/excel/HP051992911033.asp

It lists the specs and limits for charts, worksheets, etc, for X
2003

HTH
J


- Hide quoted text -

a lot
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

RETART!!
You are the biggest idiot ive ever seen in my entired god damn life. I went way the hell past 255. Get your facts in order before you start acting all smart and PISS. You little dumbbutt!

hey!!!
watch your fcking language you mother fcking batard dck licking fat fck of a douch go eat some gouche chees you stupid dick neck >:(


Submitted via EggHeadCafe - Software Developer Portal of Choice
File-Based Cache for Web and non-Web Apps plus Extend ASP.NET 4.0 OutputCacheProvider
http://www.eggheadcafe.com/tutorial...dfe-9f7a28f4d58e/filebased-cache-for-web.aspx
 
Back
Top