Reference: Workbook Limits

Limit Type	Notes
Workbook overall size	20 million cells. Whenever you modify a workbook that exceeds the limit, a warning displays. It's very important that you take action to reduce the workbook size. Overly large workbooks don't perform well and eventually will fail to open or save. Here are some actions that you can do if your workbook is approaching the limit: Reduce the number of cells in the workbook that have any data associated with them, such as formulas, values, or formatting. For most cells, the best way to fully clear them is to select the range of cells and select Edit Clear All . For cells in live data, try reducing the number of columns or rows. Consider creating more concise reports to limit the number of rows returned. For cells in pivot areas, try adjusting the pivot configuration to reduce the overall number of rows and columns produced. Split large workbooks into two or more smaller workbooks.
Uploads of spreadsheet files (XLSX, XLS, CSV, TSV, JWF, HTML)	20 million cells. Worksheets also follows the Workday overall file upload limit of 30 MB.
Downloads of workbooks	20 million cells.
Report data in a workbook as live data	20 million cells. This limit is based on the amount of data being placed into workbook cells. The report can have more than 20 million cells of data; your live data prompt selections and other filters should result in a workbook size that is below the limit.
Report data in a workbook as static values	5 million cells.
Pivot table results	1,000,000
Data points in a chart	100,000
Sheets in a workbook	256
Columns in a workbook	16,384
Rows in a workbook	1,048,576
Characters in a single cell	The limit is generally considered to be 32,767 characters per cell, but it is usually lower in practice. Internally, characters are measured in bytes; each character can require from 1 to 3 bytes. For example, most English characters are 1 byte each, but double-width characters can require up to 3 bytes.
Report run time	Advanced reports time out after 30 minutes. Matrix and composite reports don't have this limit because they run as a background process.

Workbook overall size

20 million cells.

Whenever you modify a workbook that exceeds the limit, a warning displays. It's very important that you take action to reduce the workbook size. Overly large workbooks don't perform well and eventually will fail to open or save.

Here are some actions that you can do if your workbook is approaching the limit:

Reduce the number of cells in the workbook that have any data associated with them, such as formulas, values, or formatting. For most cells, the best way to fully clear them is to select the range of cells and select

Edit

Clear

All

.

For cells in live data, try reducing the number of columns or rows. Consider creating more concise reports to limit the number of rows returned.

For cells in pivot areas, try adjusting the pivot configuration to reduce the overall number of rows and columns produced.

Split large workbooks into two or more smaller workbooks.

Uploads of spreadsheet files (XLSX, XLS, CSV, TSV, JWF, HTML)

20 million cells.

Worksheets also follows the Workday overall file upload limit of 30 MB.

Downloads of workbooks

20 million cells.

Report data in a workbook as live data

20 million cells.

This limit is based on the amount of data being placed into workbook cells. The report
can have more than 20 million cells of data; your live data prompt selections and other filters should result in a workbook size that is below the limit.

Report data in a workbook as static values

5 million cells.

Pivot table results

1,000,000

Data points in a chart

100,000

Sheets in a workbook

256

Columns in a workbook

16,384

Rows in a workbook

1,048,576

Characters in a single cell

The limit is generally considered to be 32,767 characters per cell, but it is usually lower in practice. Internally, characters are measured in bytes; each character can require from 1 to 3 bytes. For example, most English characters are 1 byte each, but double-width characters can require up to 3 bytes.

Report run time

Advanced reports time out after 30 minutes. Matrix and composite reports don't have this limit because they run as a background process.