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?

This could be due to the fact that your pivot data source is not dynamic.You should find teh necessary info ( also XL2013) at this place

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Many thanks Pecoflyer for your help on this.