Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create pivot table from existing pivot table in excel 2007 Udayraj Dhulekar Excel Discussion (Misc queries) 2 July 8th 13 08:22 PM
refresh a new worsheet on pivot table refresh [email protected] Excel Worksheet Functions 0 February 9th 07 07:39 PM
Can Excel Viewer be used to refresh data in a pivot table? Brian O'Neill Excel Discussion (Misc queries) 1 July 30th 06 01:37 AM
Excel 2k Pivot Table refresh scenario GDCross Excel Discussion (Misc queries) 1 June 1st 06 09:12 PM
Excel Pivot Table Refresh Question David D Excel Discussion (Misc queries) 2 August 25th 05 01:00 PM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"