Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-04-2014, 02:48 PM
angie450 angie450 is offline Excel pivot table with a DATE value field for some reason stops at a certain date Windows 7 64bit Excel pivot table with a DATE value field for some reason stops at a certain date Office 2003
Novice
Excel pivot table with a DATE value field for some reason stops at a certain date
 
Join Date: Feb 2014
Posts: 6
angie450 is on a distinguished road
Default Excel pivot table with a DATE value field for some reason stops at a certain date

Hello,



I'm attaching an example of the Excel spreadsheet I'm working with. We're entering details and then I create a Pivot Table on a separate sheet (which you can see in the "Summary" tab). I choose DATE to be my row value, but for some reason it stops showing data after 3/21/14. I have tried recreating the pivot table, clearing all filters, etc. but it always stops at 3/21/14. It's strange because I used the same Excel file to create different spreadsheets for different users, and most of them (except for one ) will show all dates, but this one stops at 3/21/14. Any ideas? Thanks for all your help! I'm really at a loss here.
Attached Files
File Type: xlsm problem pivot table 3-21-14.xlsm (66.4 KB, 3 views)
Reply With Quote
  #2  
Old 08-05-2014, 06:37 AM
whatsup whatsup is offline Excel pivot table with a DATE value field for some reason stops at a certain date Windows 7 64bit Excel pivot table with a DATE value field for some reason stops at a certain date Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi

You need to refresh your table. Don't know why, maybe it's related to the aplied protection of Sheet1?

- Unprotect Sheet1
- Select a cell of your table1
- choose from the ribbon table tools ---> Refresh ---> refresh all

This will also refresh your pivot table and all data should be shown.
Reply With Quote
  #3  
Old 08-19-2014, 08:50 AM
angie450 angie450 is offline Excel pivot table with a DATE value field for some reason stops at a certain date Windows 7 64bit Excel pivot table with a DATE value field for some reason stops at a certain date Office 2003
Novice
Excel pivot table with a DATE value field for some reason stops at a certain date
 
Join Date: Feb 2014
Posts: 6
angie450 is on a distinguished road
Default

Thanks so much! That's exactly what it was.
Reply With Quote
Reply

Tags
pivot table;tables

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel pivot table with a DATE value field for some reason stops at a certain date Group Date by Quarter in PIVOT TABLE shilabrow Excel 6 04-24-2014 10:44 AM
Excel pivot table with a DATE value field for some reason stops at a certain date Pivot table date grouping differentdrummer Excel 2 12-04-2013 03:07 PM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
Excel pivot table with a DATE value field for some reason stops at a certain date Date Field to add 10 Days to Current Date Erbwon Word 6 11-12-2012 06:17 PM
Excel Pivot Table Calculated Field BertLady Excel 0 05-21-2012 10:51 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft