How I refresh pivot table report?

P

Perplexed

After designing a pivot table, I would like to reuse it with the same data
structure, but live (varying) contents (data). Any attempts to do so did not
work . The only way I could refresh it was to delete a worksheet containing
pivot table structure and rebuild it again from scratch. I assumed that pivot
tables are designed for re-use but it does not seem to be a valid assumption.
 
A

Alojz

Ctrl+Alt+F5 (refresh all) in Excel2007, in Excel2003 find the tool button
with exclamation mark (maybe u need to be in Pivot table, cannot check now).
 
A

Alojz

Sorry for double posting, not sure if my previous second remark was posted.
My first answer works only for situation when u change data already included
in source data area. If u add new data, u have to use pivot table wizard,
clicking on back button u can expand original area.

HTH,
Alojz
 

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

Dealing with a Pivot Table (when I don't want to) 0
Formula to Look up values from a pivot table 1
Pivot table report invalid 0
Pivot Table Refresh? 2
Pivot ungrouping on refresh? 3
Pivot Tables and Filter Criteria Display 0
Pivot 0
Pivot Table Refresh not working properly 1

Top