View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default pivot table will not refresh

What is the source data for the pivot table?
If it's a worksheet data range that is populated by a query, you'd need to
re-run the query to pull the latest data into the range, then right click on
the pivot table and select Refresh. (it won't automatically refresh based on
a change in the source data.)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"CN" wrote:

I use Excel 2003 and work with pivot tables on a daily basis. I did not
realize they were supposed to be able to refresh until a co-worker told me
about this. I am not able to make this work. She is not able to make this
work at my computer. Is there something obvious that I am not doing right???