Pivot Dynamic Range not working

[Mr Denove]

Morning all,

So moving on from the autofilter issue now resolved. My next issue is I have a data range that has several rows of data removed. Then I apply the dynamic pivot range code to refresh my pivot(s) to the new data.
However, the code still keeps going to the last row where the data used to be, not where the remaining data is.

ie 100 rows, if 50 are removed my range is still looking at 100.

Can anyone advise how to resolve please? I cant filter out blanks as some relevant data has a blank field which I need to include.

Thanks in advance.
Stuart

 

[arthurbr]

There are several solutions described here

 

[Mr Denove]

Hi Arthur,

Ive just re run my code having clicked on the Number of items to retain and changed to None beforehand and im still getting the phantom data.
Might just have to run a formula that will stop at the last row entry and use that as a filter as cant see how else to get round it but could really do without having the pivot working on almost double the rows it should be.

 

[arthurbr]

Did you check the link provided?