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

Pivot Table Refresh? 2
how do i refresh a pivot table report in a shared file 1
Pivot Table Refresh not working properly 1
Pivot ungrouping on refresh? 3
Refresh pivot table on protected sheet 3
Automatically Refresh pivot table 6
How do I save Pivot Table Data 4
One pivot table cannot overlap another pivot issue. 1

Top