I just upgraded from 2003 to 2010 Excel. However, when I view my pivot tables all the most current information is there, but as soon as I click on my pivot charts it does not show the last day. These charts have always worked before, and I never had a issue with them not updating as long as my pivot table was updated. Does anyone know how to get my last day to show up, for I am always one day short on my chart every day it only goes upto the prior day.