Posted by Susie on May 21, 2001 7:44 AM
My workbook has 3 sheets; 1 is the database, 2 is the Pivot Table, 3 is a spreadsheet that requires getting certain info. from the Pivot Table. Example, I'm looking for Total Number of Females and this number is in the Pivot Table in G100. On the 3rd sheet in the appropriate column, I type: =G100 and it returns the number, let's say 100. The problem is if the database changes which changes the pivot table and changes the location of the number. Example, I add a new employee in the database and now the total number is on G101. Now the 3rd sheet where I have the formula = G100 is not correct now.