Pivot Table Limitations and specifications. It helps us to know the Pivot Table or Pivot Chart limits in MS Office applications.
Pivot Table Limitations & specifications
Let us see the Pivot Table or Pivot Chart Limitations & specifications
| Description | Maximum limit |
|---|---|
| We can create any number of Pivot Table reports on a sheet | Limited by available memory |
| We can create any number of row or column fields in a Pivot Table report | Limited by available memory |
| We can create any number of calculated item formulas in a Pivot Table report | Limited by available memory |
| We can create any number of calculated item formulas in a Pivot Chart report | Limited by available memory |
| Unique items per field | 10,48,576 |
| Apply filters in a Pivot Table report | 256 (Limited by available memory) |
| Value fields in a Pivot Table report | 256 |
| Report filters in a Pivot Chart report | 256 (Limited by available memory) |
| Value fields in a Pivot Chart report | 256 |
| Length of the MDX name for a Pivot Table item | 32,767 |
| Length for a relational Pivot Table string | 32,767 |
| Items displayed in filter drop-down lists | 10,000 |
Other Useful Resources:
Click on the following links of the useful resources. These helps to learn and gain more knowledge.
VBA Tutorial VBA Functions List VBA Arrays VBA Text Files VBA Tables
VBA Editor Keyboard Shortcut Keys List VBA Interview Questions & Answers Blog
