Forum Discussion
Pivot table won't refresh.
I was having the same problem and found a different cause/solution that people may or may not know about. My pivot table data source was from a "table" in Excel not just a worksheet. When you add a new column or row the table grows to include the new dimensions. Formulas and such also automatically extend to the new cells. It's a nice feature.
I added a new column to the right side of my table and, indeed, the table expanded and included my new column. However, refreshing the pivot table that drew from this table did nothing - it would not update. Eventually I discovered the "Pivot Table Analyze" menu and the "Change Data Source" option. Selecting this took me to my data table and sure enough, the new column was not included. Rubber-banded the table and the selection window reflected "Table 1" and everything worked as expected after that.
Hope this helps someone.
