Problem with Pivots
Posted on 2014-04-28
is there a way to prevent the 'Data Source' range from changing when data is changed.
I have set up a pivot with a data range called RawData. The range for this is ='Raw Data'!$A$7:$AL$10000
However, if tomorrow the total rows are 5000 the pivot will change itself to 5000 which means the following day when there are 8000 rows it will stay at 5000 and my pivot will be incorrect.