Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Refresh Pivot Table
Just started using this Home/Student version.
Have created a dataset of stock prices for various stocks for each day starting in January 2007 to present day. Prior to today, the list ended with April 18. Today I added April 19, 20 and 23. There are no "holes" in the data. When I went to the Pivot Table that showed all dates between Jan and April 18, I expected it to refresh when I clicked on the "refresh" icon on the tool bar. No joy. I then went back to the dataset and made a brand new pivot table. In Excel 2003, it would warn me that I was using too much memory if I created a new PT using the same dataset. Not with 2007. It created the PT and Included the missing dates to April 23. What did I do wrong that caused the original PT not to refresh when I clicked on the "refresh" icon? Your guidance is appreciated. k |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
Can Excel Viewer be used to refresh data in a pivot table? | Excel Discussion (Misc queries) | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
Excel Pivot Table Refresh Question | Excel Discussion (Misc queries) |