|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Thanks so much! That's exactly what it was.
|
Tags |
pivot table;tables |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Group Date by Quarter in PIVOT TABLE | shilabrow | Excel | 6 | 04-24-2014 10:44 AM |
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 |
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 |