Excel specs and limits

Excel specs and limits

Newer variations Workplace 2010 Workplace 2007

Worksheet and workbook specs and limits

Function

Most restrict

Open workbooks

Restricted by accessible reminiscence and system sources

Whole variety of rows and columns on a worksheet

1,048,576 rows by 16,384 columns

Column width

255 characters

Row top

409 factors

Web page breaks

1,026 horizontal and vertical

Whole variety of characters {that a} cell can comprise

32,767 characters

Characters in a header or footer

255

Most variety of line feeds per cell

253

Sheets in a workbook

Restricted by accessible reminiscence (default is 1 sheet)

Colours in a workbook

16 million colours (32 bit with full entry to 24 bit coloration spectrum)

Named views in a workbook

Restricted by accessible reminiscence

Distinctive cell codecs/cell kinds

64,000

Fill kinds

256

Line weight and kinds

256

Distinctive font varieties

1,024 international fonts accessible to be used; 512 per workbook

Quantity codecs in a workbook

Between 200 and 250, relying on the language model of Excel that you’ve got put in

Names in a workbook

Restricted by accessible reminiscence

Home windows in a workbook

Restricted by accessible reminiscence

Hyperlinks in a worksheet

66,530 hyperlinks

Panes in a window

4

Linked sheets

Restricted by accessible reminiscence

Situations

Restricted by accessible reminiscence; a abstract report reveals solely the primary 251 eventualities

Altering cells in a situation

32

Adjustable cells in Solver

200

Customized features

Restricted by accessible reminiscence

Zoom vary

10 % to 400 %

Stories

Restricted by accessible reminiscence

Kind references

64 in a single type; limitless when utilizing sequential types

Undo ranges

100

Fields in a knowledge type

32

Workbook parameters

255 parameters per workbook

Gadgets displayed in filter drop-down lists

10,000

Noncontiguous cells that may be chosen

2,147,483,648 cells

Most limits of reminiscence storage and file measurement for Knowledge Mannequin workbooks

32-bit setting is topic to 2 gigabytes (GB) of digital tackle area, shared by Excel, the workbook, and add-ins that run in the identical course of. A knowledge mannequin’s share of the tackle area may run as much as 500 – 700 megabytes (MB), however may very well be much less if different knowledge fashions and add-ins are loaded.

64-bit setting imposes no onerous limits on file measurement. Workbook measurement is restricted solely by accessible reminiscence and system sources.

Excel 2016 gives the Massive Tackle Conscious performance that lets 32-bit Excel 2016 eat twice the reminiscence when customers work on a 64-bit Home windows working system. For extra info, see Massive Tackle Conscious functionality change for Excel.

Notice: Including tables to the Knowledge Mannequin will increase the file measurement. For those who do not plan to create complicated Knowledge Mannequin relationships utilizing many knowledge sources and knowledge varieties in your workbook, uncheck the Add this knowledge to the Knowledge Mannequin field once you import or create tables, pivot tables, or knowledge connections.

For extra info, see Knowledge Mannequin specification and limits.

Processor Cores

64

Calculation specs and limits

Function

Most restrict

Quantity precision

15 digits

Smallest allowed adverse quantity

-2.2251E-308

Smallest allowed optimistic quantity

2.2251E-308

Largest allowed optimistic quantity

9.99999999999999E+307

Largest allowed adverse quantity

-9.99999999999999E+307

Largest allowed optimistic quantity through system

1.7976931348623158e+308

Largest allowed adverse quantity through system

-1.7976931348623158e+308

Size of system contents

8,192 characters

Inner size of system

16,384 bytes

Iterations

32,767

Worksheet arrays

Restricted by accessible reminiscence

Chosen ranges

2,048

Arguments in a operate

255

Nested ranges of features

64

Person outlined operate classes

255

Variety of accessible worksheet features

341

Measurement of the operand stack

1,024

Cross-worksheet dependency

64,000 worksheets that may seek advice from different sheets

Cross-worksheet array system dependency

Restricted by accessible reminiscence

Space dependency

Restricted by accessible reminiscence

Space dependency per worksheet

Restricted by accessible reminiscence

Dependency on a single cell

Four billion formulation that may depend upon a single cell

Linked cell content material size from closed workbooks

32,767

Earliest date allowed for calculation

January 1, 1900 (January 1, 1904, if 1904 date system is used)

Newest date allowed for calculation

December 31, 9999

Largest period of time that may be entered

9999:59:59

Charting specs and limits

Function

Most restrict

Charts linked to a worksheet

Restricted by accessible reminiscence

Worksheets referred to by a chart

255

Knowledge sequence in a single chart

255

Knowledge factors in a knowledge sequence for 2-D charts

Restricted by accessible reminiscence

Knowledge factors in a knowledge sequence for 3-D charts

Restricted by accessible reminiscence

Knowledge factors for all knowledge sequence in a single chart

Restricted by accessible reminiscence

PivotTable and PivotChart report specs and limits

Function

Most restrict

PivotTable experiences on a sheet

Restricted by accessible reminiscence

Distinctive objects per subject

1,048,576

Row or column fields in a PivotTable report

Restricted by accessible reminiscence

Report filters in a PivotTable report

256 (could also be restricted by accessible reminiscence)

Worth fields in a PivotTable report

256

Calculated merchandise formulation in a PivotTable report

Restricted by accessible reminiscence

Report filters in a PivotChart report

256 (could also be restricted by accessible reminiscence)

Worth fields in a PivotChart report

256

Calculated merchandise formulation in a PivotChart report

Restricted by accessible reminiscence

Size of the MDX identify for a PivotTable merchandise

32,767

Size for a relational PivotTable string

32,767

Gadgets displayed in filter drop-down lists

10,000

Workbooks with the “Allow changes by more than one user…” setting enabled

If the Permit adjustments by a couple of person… setting is on for a workbook, then the next info applies. This setting is accessible by clicking the Assessment tab > Share Workbook. Notice that in newer variations of Excel, the Share Workbook button has been hidden. To unhide it, click on File > Choices > Fast Entry Toolbar. Open the checklist underneath Select instructions from and choose All Instructions. Scroll down that checklist till you see Share Workbook (Legacy). Choose that merchandise and click on Add. Click on OK. The Share Workbook button is now on the prime of the Excel window and appears like this: Share Workbook

Function

Most restrict

Customers who can open the file on the identical time

256

Private views within the workbook

Restricted by accessible reminiscence

Days that change historical past is maintained

32,767 (default is 30 days)

Workbooks that may be merged at one time

Restricted by accessible reminiscence

Cells that may be highlighted

32,767

Colours used to determine adjustments made by completely different customers when change highlighting is turned on

32 (every person is recognized by a separate coloration; adjustments made by the present person are highlighted with navy blue)

Excel tables within the workbook

0 (zero)

Notice: A workbook that accommodates a number of Excel tables can not have the Permit adjustments by a couple of person… setting enabled.

Worksheet and workbook specs and limits

Function

Most restrict

Open workbooks

Restricted by accessible reminiscence and system sources

Whole variety of rows and columns on a worksheet

1,048,576 rows by 16,384 columns

Column width

255 characters

Row top

409 factors

Web page breaks

1,026 horizontal and vertical

Whole variety of characters {that a} cell can comprise

32,767 characters

Characters in a header or footer

255

Most variety of line feeds per cell

253

Sheets in a workbook

Restricted by accessible reminiscence (default is Three sheets)

Colours in a workbook

16 million colours (32 bit with full entry to 24 bit coloration spectrum)

Named views in a workbook

Restricted by accessible reminiscence

Distinctive cell codecs/cell kinds

64,000

Fill kinds

256

Line weight and kinds

256

Distinctive font varieties

1,024 international fonts accessible to be used; 512 per workbook

Quantity codecs in a workbook

Between 200 and 250, relying on the language model of Excel that you’ve got put in

Names in a workbook

Restricted by accessible reminiscence

Home windows in a workbook

Restricted by accessible reminiscence

Hyperlinks in a worksheet

66,530 hyperlinks

Panes in a window

4

Linked sheets

Restricted by accessible reminiscence

Situations

Restricted by accessible reminiscence; a abstract report reveals solely the primary 251 eventualities

Altering cells in a situation

32

Adjustable cells in Solver

200

Customized features

Restricted by accessible reminiscence

Zoom vary

10 % to 400 %

Stories

Restricted by accessible reminiscence

Kind references

64 in a single type; limitless when utilizing sequential types

Undo ranges

100

Fields in a knowledge type

32

Workbook parameters

255 parameters per workbook

Gadgets displayed in filter drop-down lists

10,000

Noncontiguous cells that may be chosen

2,147,483,648 cells

Processor Cores

64

Calculation specs and limits

Function

Most restrict

Quantity precision

15 digits

Smallest allowed adverse quantity

-2.2251E-308

Smallest allowed optimistic quantity

2.2251E-308

Largest allowed optimistic quantity

9.99999999999999E+307

Largest allowed adverse quantity

-9.99999999999999E+307

Largest allowed optimistic quantity through system

1.7976931348623158e+308

Largest allowed adverse quantity through system

-1.7976931348623158e+308

Size of system contents

8,192 characters

Inner size of system

16,384 bytes

Iterations

32,767

Worksheet arrays

Restricted by accessible reminiscence

Chosen ranges

2,048

Arguments in a operate

255

Nested ranges of features

64

Person outlined operate classes

255

Variety of accessible worksheet features

341

Measurement of the operand stack

1,024

Cross-worksheet dependency

64,000 worksheets that may seek advice from different sheets

Cross-worksheet array system dependency

Restricted by accessible reminiscence

Space dependency

Restricted by accessible reminiscence

Space dependency per worksheet

Restricted by accessible reminiscence

Dependency on a single cell

Four billion formulation that may depend upon a single cell

Linked cell content material size from closed workbooks

32,767

Earliest date allowed for calculation

January 1, 1900 (January 1, 1904, if 1904 date system is used)

Newest date allowed for calculation

December 31, 9999

Largest period of time that may be entered

9999:59:59

Charting specs and limits

Function

Most restrict

Charts linked to a worksheet

Restricted by accessible reminiscence

Worksheets referred to by a chart

255

Knowledge sequence in a single chart

255

Knowledge factors in a knowledge sequence for 2-D charts

Restricted by accessible reminiscence

Knowledge factors in a knowledge sequence for 3-D charts

Restricted by accessible reminiscence

Knowledge factors for all knowledge sequence in a single chart

Restricted by accessible reminiscence

PivotTable and PivotChart report specs and limits

Function

Most restrict

PivotTable experiences on a sheet

Restricted by accessible reminiscence

Distinctive objects per subject

1,048,576

Row or column fields in a PivotTable report

Restricted by accessible reminiscence

Report filters in a PivotTable report

256 (could also be restricted by accessible reminiscence)

Worth fields in a PivotTable report

256

Calculated merchandise formulation in a PivotTable report

Restricted by accessible reminiscence

Report filters in a PivotChart report

256 (could also be restricted by accessible reminiscence)

Worth fields in a PivotChart report

256

Calculated merchandise formulation in a PivotChart report

Restricted by accessible reminiscence

Size of the MDX identify for a PivotTable merchandise

32,767

Size for a relational PivotTable string

32,767

Gadgets displayed in filter drop-down lists

10,000

Workbooks with the “Allow changes by more than one user…” setting enabled

If the Permit adjustments by a couple of person… setting is on for a workbook, then the next info applies. This setting is accessible by clicking the Assessment tab > Share Workbook.

Function

Most restrict

Customers who can open and share the file on the identical time

256

Private views within the workbook

Restricted by accessible reminiscence

Days that change historical past is maintained

32,767 (default is 30 days)

Workbooks that may be merged at one time

Restricted by accessible reminiscence

Cells that may be highlighted within the workbook

32,767

Colours used to determine adjustments made by completely different customers when change highlighting is turned on

32 (every person is recognized by a separate coloration; adjustments made by the present person are highlighted with navy blue)

Excel tables within the workbook

0 (zero)

Notice: A workbook that accommodates a number of Excel tables can not have the Permit adjustments by a couple of person… setting enabled.

Worksheet and workbook specs and limits

Function

Most restrict

Open workbooks

Restricted by accessible reminiscence and system sources

Whole variety of rows and columns on a worksheet

1,048,576 rows by 16,384 columns

Column width

255 characters

Row top

409 factors

Web page breaks

1,026 horizontal and vertical

Whole variety of characters {that a} cell can comprise

32,767 characters

Characters in a header or footer

255

Most variety of line feeds per cell

253

Sheets in a workbook

Restricted by accessible reminiscence (default is Three sheets)

Colours in a workbook

16 million colours (32 bit with full entry to 24 bit coloration spectrum)

Named views in a workbook

Restricted by accessible reminiscence

Distinctive cell codecs/cell kinds

64,000

Fill kinds

256

Line weight and kinds

256

Distinctive font varieties

1,024 international fonts accessible to be used; 512 per workbook

Quantity codecs in a workbook

Between 200 and 250, relying on the language model of Excel that you’ve got put in

Names in a workbook

Restricted by accessible reminiscence

Home windows in a workbook

Restricted by accessible reminiscence

Hyperlinks in a worksheet

66,530 hyperlinks

Panes in a window

4

Linked sheets

Restricted by accessible reminiscence

Situations

Restricted by accessible reminiscence; a abstract report reveals solely the primary 251 eventualities

Altering cells in a situation

32

Adjustable cells in Solver

200

Customized features

Restricted by accessible reminiscence

Zoom vary

10 % to 400 %

Stories

Restricted by accessible reminiscence

Kind references

64 in a single type; limitless when utilizing sequential types

Undo ranges

100

Fields in a knowledge type

32

Workbook parameters

255 parameters per workbook

Filter drop-down lists

10,000

Calculation specs and limits

Function

Most restrict

Quantity precision

15 digits

Smallest allowed adverse quantity

-2.2251E-308

Smallest allowed optimistic quantity

2.2251E-308

Largest allowed optimistic quantity

9.99999999999999E+307

Largest allowed adverse quantity

-9.99999999999999E+307

Largest allowed optimistic quantity through system

1.7976931348623158e+308

Largest allowed adverse quantity through system

-1.7976931348623158e+308

Size of system contents

8,192 characters

Inner size of system

16,384 bytes

Iterations

32,767

Worksheet arrays

Restricted by accessible reminiscence

Chosen ranges

2,048

Arguments in a operate

255

Nested ranges of features

64

Person outlined operate classes

255

Variety of accessible worksheet features

341

Measurement of the operand stack

1,024

Cross-worksheet dependency

64,000 worksheets that may seek advice from different sheets

Cross-worksheet array system dependency

Restricted by accessible reminiscence

Space dependency

Restricted by accessible reminiscence

Space dependency per worksheet

Restricted by accessible reminiscence

Dependency on a single cell

Four billion formulation that may depend upon a single cell

Linked cell content material size from closed workbooks

32,767

Earliest date allowed for calculation

January 1, 1900 (January 1, 1904, if 1904 date system is used)

Newest date allowed for calculation

December 31, 9999

Largest period of time that may be entered

9999:59:59

Charting specs and limits

Function

Most restrict

Charts linked to a worksheet

Restricted by accessible reminiscence

Worksheets referred to by a chart

255

Knowledge sequence in a single chart

255

Knowledge factors in a knowledge sequence for 2-D charts

32,000

Knowledge factors in a knowledge sequence for 3-D charts

4,000

Knowledge factors for all knowledge sequence in a single chart

256,000

PivotTable and PivotChart report specs and limits

Function

Most restrict

PivotTable experiences on a sheet

Restricted by accessible reminiscence

Distinctive objects per subject

1,048,576

Row or column fields in a PivotTable report

Restricted by accessible reminiscence

Report filters in a PivotTable report

256 (could also be restricted by accessible reminiscence)

Worth fields in a PivotTable report

256

Calculated merchandise formulation in a PivotTable report

Restricted by accessible reminiscence

Report filters in a PivotChart report

256 (could also be restricted by accessible reminiscence)

Worth fields in a PivotChart report

256

Calculated merchandise formulation in a PivotChart report

Restricted by accessible reminiscence

Size of the MDX identify for a PivotTable merchandise

32,767

Size for a relational PivotTable string

32,767

Workbooks with the “Allow changes by more than one user…” setting enabled

If the Permit adjustments by a couple of person… setting is on for a workbook, then the next info applies. This setting is enabled when utilizing Shared Workbooks.

Function

Most restrict

Customers who can open and share the workbook on the identical time

256

Private views within the workbook

Restricted by accessible reminiscence

Days that change historical past is maintained

32,767 (default is 30 days)

Workbooks that may be merged at one time

Restricted by accessible reminiscence

Cells that may be highlighted

32,767

Colours used to determine adjustments made by completely different customers when change highlighting is turned on

32 (every person is recognized by a separate coloration; adjustments made by the present person are highlighted with navy blue)

Excel tables within the workbook

0 (zero)

Notice: A workbook that accommodates a number of Excel tables can not have the Permit adjustments by a couple of person… setting enabled.

Prime of Web page

Leave a Reply