A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pivot Tables 2003 v 2007



 
 
Thread Tools Display Modes
  #1  
Old May 12th, 2010, 09:18 PM posted to microsoft.public.excel.misc
James C.
external usenet poster
 
Posts: 16
Default Pivot Tables 2003 v 2007

So I have an odd question.. I have a pivot table (created in Excel 2003) that
links to data (also created in Excel 2003). This Pivot Table has a report
filter that allows me to select dates. Right now I do not have the "all"
selected in this report filter but actually have the days selected. When I
add new data to the data.xls and refresh my pivot table it automatically adds
the new dates and selects them automatically to show up in my Pivot table
results... This is what I want to happen.

Now, I also have a pivot table (created in Excel 2007) that links to the
same data (created in Excel 2003) from before. When I add new data and
refresh the Excel 2007 Pivot table it adds the new dates but does NOT
automatically select them to include in my pivot results. I have search all
over but cannot find the setting that controls this

Anyone know why this would be?
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:27 PM.


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