Hi All

Sorry if this has already been asked but I have searched and could not find the answer.

I have a workbook with a number of sheets. A lot of the sheets have pivot tables which are looking at a main data sheet. the pivot data is the same for all pivots and is a dynamic named range so that when the script runs it finishes by refreshing all the pivots. This all works fine apart from one thing.

All of the pivots are different but do have one thing in common, the row data is always filtered to ignore blanks. If when the data is refreshed new rows are added they seem to be automatically filtered out.

I am using the code below to refresh the pivots, is there any way to refresh all the pivots without naming each one to only filter out "Blanks"???


Please Login or Register  to view this content.

Thanks in advance

Jim