updating pivot table

  • Thread starter Thread starter GeorgeJ
  • Start date Start date
G

GeorgeJ

I have created a pivot table on another sheet from the sheet on which the
data for the table is located. How do I arrange so that when I change a
value in the original data, the pivot table is updated? What I have been
doing is

1) changing a value in the original data
2) activating the sheet on which the pivot table is located
3) clicking inside the pivot table


When I do this I get a popup box relating to the pivot table. At the lower
right hand of the box there is a button which says "Update" but this button
appears faint. e. e. its not selectable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding to an existing Pivot Table 7
Pivot Table - Changes 5
Referencing a pivot tables Grand Totals Column 1
about pivot table 1
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table update 8
Pasted Pivot Table looks at old sheet 1
Pivot Table Update 3

Back
Top