Excel pivot table with a DATE value field for some reason stops at a certain date

whatsup · #1 08-05-2014, 06:37 AM

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.

angie450 · #2 08-19-2014, 08:50 AM

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

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