Thread: Excel pivot table with a DATE value field for some reason stops at a certain date
View Single Post
 
Old 08-05-2014, 06:37 AM
whatsup whatsup is offline Windows 7 64bit 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