pivot table will not refresh
The source of my data is a worksheet that I add additional data to on a daily
basis. I am cutting lines of data from a csv file and then pasting into the
Excel file. What I have to do is create a new pivot table each day. If I
simple try to refresh it does not work. It seems so straight forward. I am
going to have our IT group re-install Office because I can't think of
anything else. I appreciate your response!!!
"Ron Coderre" wrote:
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???
|