Sort references: 64 references in a single sort unlimited when using sequential sortsįields in a data form: Maximum of 32 fields Scenarios: Limited by available memory (a summary report shows only the first 251 scenarios)Ĭhanging cells in a scenario: Maximum of 32 changing cellsĪdjustable cells in Solver: Maximum of 200 adjustable cellsĬustom functions: Limited by available memory Hyperlinks in a worksheet: Maximum of 66,530 hyperlinks Number formats in a workbook: Maximum between 200 and 250, depending on the language version of Excel installed

Unique font types: Maximum of 1,024 global fonts available for use or 512 per workbook Unique cell formats/cell styles: Maximum of 64,000 Maximum number of line feeds per cell: Maximum of 253 linesĬolors in a workbook: Maximum of 16 million colors (32 bit with full access to 24 bit color spectrum) Number of characters that a cell can contain: Maximum of 32,767 charactersĬharacters in a header or footer: Maximum of 255 characters Page breaks: Maximum of 1,026 horizontal and vertical Linked sheets: Limited by available memory Zoom range: Maximum of 400 percent (minimum is 10 percent) Named views in a workbook: Limited by available memory Windows in a workbook: Limited by available memory Names in a workbook: Limited by available memory Sheets in a workbook: Limited by available memory (default is 1 sheet) Open workbooks: Limited by available memory and system resources Worksheet size: Maximum of 1,048,576 rows and 16,384 columns In this example, Order ID 10252 now shows in the pivot table results.Excel Worksheet and Workbook Maximum Limits and Specifications Now when you return to your pivot table, it should automatically refresh the pivot table and display the information from the new data source. In this example, we want to change the range from Sheet1!$A$1:$F$16 to Sheet1!$A$1:$F$17 because we have added one more row to our data in Sheet1. When the Change PivotTable Data Source window appears, change the Table/Range value to the new data source that you want for your pivot table and then click on the OK button. In the Data group, click on Change Data Source button and select 'Change Data Source' from the popup menu. Select the Analyze tab from the toolbar at the top of the screen.

You now should see 2 new tabs appear in the toolbar called Analyze and Design. In this example, we have selected cell A1 on Sheet2.

Select any cell in the pivot table to reveal more pivot table options in the toolbar. To change the data source of an existing pivot table in Excel 2016, you will need to do the following steps: If you want to follow along with this tutorial, download the example spreadsheet.ĭownload Example Steps to Change the Data Source of a Pivot Table

Excel 2016 pivot table cheat sheet