Hello all!
Every week, I have to update this excel, which has three sheets: one with the database (in which the range varies every week, it's never the same number of rows), a sheet with a pivot table with one calcuand a sheet with the pivot chart and respective slicers. The only the sheet will be available to the user will be the sheet "Analysis".
So, as the number of rows of every week is difference, the datasource/the range of the pivot table is AA:EE, so I would only need to refresh the pivot table every week.
The problem is that in the pivot chart and in the slicers, the option "Blank" appears, even though the option "Hide Items with no data is checked".
Can you help me?
Thank you!
Bookmarks