Big Data Hint - missing table column(s)

Sometimes when you add columns to the detail sheet, those new columns don't show up when you do an insert/pivot table. This does not happen all the time. If it happens to you, you can work around the problem.

Method 1: Refresh the Pivot Table using this information from Microsoft - https://support.office.com/en-us/article/refresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9be2

Method 2: Increase the selected range to include your new columns.

1. When you are on the detail sheet and have just selected Insert/Pivot Table, manually change the range that Excel gives you to include your new columns.

When you do the Insert/Pivot table while you are on the detail sheet, a dialog box will appear. Instead of just hitting Enter, change the table/range line in the dialog box.

If column T is your right-most column, use detail!$A:$T

If column U is your right-most column, use detail!$A$U

2. Then complete the Insert/Pivot Table.

Method 3: Select the entire table on the detail sheet and then do the insert pivot table.

There are several quick ways to select and entire sheet (and therefore the entire table). One of these should work for you.

1. Position the cursor above and to the left of cell A1 and click

2. Position the cursor in the table and press Command + a (MAC)

3. Position the cursor in the table and press Ctrl + a (PC).