I have created a pivot table to help do basic analysis for a maintenance department. Basically, we track start/end date&time, equipment (3 lines to break down and categorize), then text for issue and corrective action, with some breakout for month, day, week, etc.
I tried to update one of my pivot table that basically tracks occurrence by day (column) and line (row). Today is December 8, we have data filling our data entry page through December 2, but my pivot table just stopped at November 17. A refresh didn't help. I have data going back to January of 2011.
I'm going to go ahead and tell you that I cheated and just created a new pivot table and went through the pains of tweaking it in, but I'd like to know how to fix it should it happen again. That has occurred to me once before and I fixed it on accident.
I tried to update one of my pivot table that basically tracks occurrence by day (column) and line (row). Today is December 8, we have data filling our data entry page through December 2, but my pivot table just stopped at November 17. A refresh didn't help. I have data going back to January of 2011.
I'm going to go ahead and tell you that I cheated and just created a new pivot table and went through the pains of tweaking it in, but I'd like to know how to fix it should it happen again. That has occurred to me once before and I fixed it on accident.