MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table


Posted by Susie on July 18, 2001 1:14 PM

I have a workbook with 3 sheets: database and the pivot table from the database. I have a third worksheet which picks up selected data from the pivot table. The problem is when I add or delete a line of data from the database and refresh the pivot table it changes the reference. Example, my summary worksheet has 3 main columns, Cost Center, Number of Employees, Average Annual Salary. My pivot table counts the number of employees in each cost center and average annual salary of each cost center. When I put in the formula in my summary worksheet under, for example, Cost Center, ='Pivot Table'!F10 where F10 returns the number of employees. However, if I add a new employee to the database, then F10 is no longer the row to find the total number so my summary spreadsheet still goes to F10, but the total is no longer in F10.


Posted by Mark W. on July 18, 2001 1:20 PM

Use GETPIVOTDATA().