I having been using a pivot table for a couple of weeks and been refreshing it each day and the information has updated. I have refreshed the pivot table today and the data is missing (cells blank). I have had this problem before and other than create a new pivot table, I do note know how to solve this. Could anyone help please?