Modificare contemporaneamente più tabelle pivot

Question

Buongiorno,&nbsp;esiste un modo per modificare contemporaneamente molteplici tabelle pivot all’intento di un foglio Excel?&nbsp;Mi spiego meglio: all’interno di un foglio Excel ho tante tabelle pivot (collegate alla stessa fonte dati) e tutte hanno la stessa variabile in riga. Vorrei sostituire la variabile in riga con un’altra variabile in tutte le pivot contemporaneamente, è possibile?&nbsp;Grazie anticipatamente per l’aiuto&nbsp;

riny_van_eekelen · Answer

Ida_Spadafora&nbsp;You may insert a slicer for the common variable and connect it to all pivot tables that shar the same pivot cache.&nbsp;(on the Pivot Table Analyze ribbon)&nbsp;(on the Slicer ribbon)&nbsp;&nbsp;

ida_spadafora · Answer

Riny_van_Eekelen&nbsp;Thank you for your advice. If I remember well, slicer is useful for apply the same filter to many pivot tables but if I would apply the same rows (or columns) (not filter) to many pivot tables, can I use slicer?

riny_van_eekelen · Answer

Ida_Spadafora&nbsp;Sorry, I thought that filtering was what you intended.

ida_spadafora · Answer

Not really! My aim is to have the same row (or column) in many pivot tables in a sheet. Instead of set this row one by one in each pivot tables of this sheet, I’d like to know if there is a way to do it at once&nbsp;thank you&nbsp;

riny_van_eekelen · Answer

Ida_Spadafora&nbsp;Don't understand what you want to do. Sorry.

Forum Discussion

Modificare contemporaneamente più tabelle pivot

Share

Resources