Make sure all the new data is included in the pivot table source. There
are instructions here for creating a dynamic data source for the pivot
table:
http://www.contextures.com/xlPivot01.html#Dynamic
srpd wrote:
After creating Pivot tables and charts, I added more data to the master
sheet. Then selected a cell in a pivot table and hit Refresh. The screen
bounced a little as the cell sizes changed but the data remained the same.
What am I doing wrong?
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com