Reference: Workbook Limits

Limit Type	Notes
Workbook overall size	20 million cells or 512 MB, whichever is less. Workbook information about the current percentage of the size limit, and the current number of cells in the workbook, is available by selecting File Info . 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. A warning displays when the workbook reaches the size limit. If the workbook reaches 110% of the size limit, a warning message displays and additional changes to the workbook are not saved until you decrease the workbook size. 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.
Report data exported to a workbook	A specific limit hasn't been established, but the export limit is lower than the overall workbook limit. If your export doesn't work, consider making the report smaller before exporting to a workbook. Instead of exporting to a workbook, consider creating a new workbook and then adding the report data into it using the Add Live Data feature. First you need to enable the report for Worksheets by selecting Enable for Worksheets in the Advanced tab of the custom report. Advanced reports also need to be enabled for Web Services.
Uploads of spreadsheet files (XLSX, XLS, CSV, TSV, JWF, HTML)	20 million cells or 512 MB, whichever is less. Worksheets also follows the Workday overall file upload limit of 30 MB.
Downloads of workbooks	20 million cells or 512 MB, whichever is less.
Report data in a workbook as live data	20 million cells or 512 MB, whichever is less. 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.
Conditional formatting areas	20 million cells.
Pivot table results	1,000,000
Data points in a chart	100,000
Sheets in a workbook	512
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.
Content copied from workbook to workbook	5 million cells or 9 MB, whichever is less.
Report run time	Advanced reports time out after 30 minutes. Matrix and composite reports don't have this limit.

Workbook overall size

20 million cells or 512 MB, whichever is less.

Workbook information about the current percentage of the size limit, and the current number of cells in the workbook, is available by selecting

File

Info

.

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.

A warning displays when the workbook reaches the size limit. If the workbook reaches 110% of the size limit, a warning message displays and additional changes to the workbook are not saved until you decrease the workbook size.

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.

Report data exported to a workbook

A specific limit hasn't been established, but the export limit is lower than the overall workbook limit. If your export doesn't work, consider making the report smaller before exporting to a workbook.

Instead of exporting to a workbook, consider creating a new workbook and then adding the report data into it using the Add Live Data
feature. First you need to enable the report for Worksheets by selecting

Enable for Worksheets

in the Advanced tab of the custom report. Advanced reports also need to be enabled for Web Services.

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

20 million cells or 512 MB, whichever is less.

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

Downloads of workbooks

20 million cells or 512 MB, whichever is less.

Report data in a workbook as live data

20 million cells or 512 MB, whichever is less.

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.

Conditional formatting areas

20 million cells.

Pivot table results

1,000,000

Data points in a chart

100,000

Sheets in a workbook

512

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.

Content copied from workbook to workbook

5 million cells or 9 MB, whichever is less.

Report run time

Advanced reports time out after 30 minutes. Matrix and composite reports don't have this limit.