sheets in a workbooks
 

Hello,

I am just wondering if anyone knows about any limitation of number of sheets
in a Excel workbook ? or may be by size ?

kanwal

sheets in a workbooks
 

kanwal

The limit on sheets is dependant upon the memory available with each
machine. It would be difficult to say it is proportional to any amount of
memory ie 256 megs = 70, 0r 512 megs = 200. Each machine utilizes memory
based on to many varibles to try to come up with a realiable answer. Why do
you ask and what are you trying to accomplish?

Mike Rogers

"kanwal" wrote:

Hello,

I am just wondering if anyone knows about any limitation of number of sheets
in a Excel workbook ? or may be by size ?

kanwal

sheets in a workbooks
 

From the Excel Help Files

Worksheet and workbook specifications
Feature Maximum limit
Open workbooks Limited by available memory and system resources
Worksheet size 65,536 rows by 256 columns
Column width 255 characters
Row height 409 points
Length of cell contents (text) 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.
Sheets in a workbook Limited by available memory (default is 3 sheets)
Colors in a workbook 56
Cell styles in a workbook 4,000
Named views in a workbook Limited by available memory
Custom number formats Limited by available memory
Names in a workbook Limited by available memory
Windows in a workbook Limited only by system resources
Panes in a window 4
Linked sheets Limited by available memory
Scenarios Limited by available memory; a summary report shows only the
first 251 scenarios
Changing cells in a scenario 32
Adjustable cells in Solver 200
Custom functions Limited by available memory
Zoom range 10 percent to 400 percent
Reports Limited by available memory
Sort references 3 in a single sort; unlimited when using sequential
sorts
Undo levels 16
Fields in a data form 32
Custom toolbars in a workbook Limited by available memory
Custom toolbar buttons Limited by available memory


Return to top

Calculation specifications
Feature Maximum limit
Number precision 15 digits
Largest allowed positive number 9.99999999999999E307
Smallest allowed negative number -9.99999999999999E307
Smallest allowed positive number 1E-307
Largest allowed negative number -1E-307
Length of formula contents 1,024 characters
Iterations 32,767
Worksheet arrays Limited by available memory. Also, arrays cannot
refer to entire columns. For example, an array cannot refer to the entire
column C:C or to the range C1:C65536. However, an array can refer to the
range C1:D65535 because the range is one row short of the maximum worksheet
size and does not include the entire C or D column.
Selected ranges 2,048
Arguments in a function 30
Nested levels of functions 7
Number of available worksheet functions 329
Earliest date allowed for calculation January 1, 1900 (January 1,
1904, if 1904 date system is used)
Latest date allowed for calculation December 31, 9999
Largest amount of time that can be entered 9999:99:99


Return to top

PivotTable report specifications
Feature Maximum limit
PivotTable reports on a sheet Limited by available memory
Items in a PivotTable report 8,000
Row or column fields in a PivotTable report Limited by available
memory
Page fields in a PivotTable report 256 (may be limited by available
memory)
Data fields in a PivotTable report 256
Calculated item formulas in a PivotTable report Limited by available
memory

sheets in a workbooks
 

You'll most likely hit a "usability limit" before an actual limit on the
number of worksheets. Workbooks with too many sheets (that number being a
matter of opinion and debate) become too difficult to use, long before they
hit an actual limit imposed by Excel and the configuration of your machine.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
"kanwal" wrote in message
...
Hello,

I am just wondering if anyone knows about any limitation of number of
sheets
in a Excel workbook ? or may be by size ?

kanwal