Forum Discussion
Modificare contemporaneamente più tabelle pivot
Buongiorno, esiste un modo per modificare contemporaneamente molteplici tabelle pivot all’intento di un foglio Excel? Mi spiego meglio: all’interno di un foglio Excel ho tante tabelle pivot (coll...
Ida_Spadafora You may insert a slicer for the common variable and connect it to all pivot tables that shar the same pivot cache.
(on the Pivot Table Analyze ribbon)
(on the Slicer ribbon)
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?
Ida_Spadafora Sorry, I thought that filtering was what you intended.
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
thank you
