View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Perplexed Perplexed is offline
external usenet poster
 
Posts: 14
Default How I refresh pivot table report?

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.