I have a number of excel 2003 spreadsheets where employees list in and out times for various functions. After creating a pivot table of the data, everything is fine....for a while. Now, about once a week, a random in-time value will block the expression of the out-time. Last week it was 8:15 am, and this week it's 10:15 am. If I change the in-time to 10:16 the out-time is displayed. When I go back to 10:15 it disappears. If I create a duplicate pivot table from the same data next to the original, it works fine.
I can't keep rebuilding the pivot every week. Any ideas as to why this is occurring would be greatly appreciated.
This one tip will help you sleep better tonight
A few seconds are all you need to get a better night's rest.