pivot tables 2016

Hello Guys I have in my excel spreadsheet a high number of pivot tables and a worksheet called "Data". I would like to know if is possible after delete some lines in this Data tab, if the all pivot tables can be refreshed automatically. Can you pls help me?

Hi Guys; I have a pivot table as below where when the equipment is serviced the last service date is not shown. which is used to show multiple charts. The table has 1000 entries and expected to double. One chart which am trying to show is a column chart where the oldest four equipment with the...

Hello all, I had this formula to return the first 5 Rows of a Table: INDEX(SUMMARY[EMPNAME],D2,1) INDEX(SUMMARY[EMPNAME],D2+1,1) INDEX(SUMMARY[EMPNAME],D2+2,1) INDEX(SUMMARY[EMPNAME],D2+3,1) INDEX(SUMMARY[EMPNAME],D2+4,1) I enter 1 in D2 and it returns the first 5 rows. Change it to 6 and it...

I have a pivot table and I wish to be able to make a slicer and in another list select the column that will populate the slicer. right now I have a test table, that I will leave in the description. I have 4 columns, and I wish to be able to select the column name in a list and that will populate...

Is There a way to use a macro to turn off unneeded Pivot Table rows? I have one of many questions on how to save time automating Pivot Tables with VBA. Mine is specific to turning rows off that are not needed. On some of the PIs there are rows that don't add value. I manually turn them off in...