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???
|