veera (searching) (52 Points)
13 November 2014I have more than 5 pivots in an excel sheet all feeded from same source of data, now if I wanted to include a new field in all pivots (field already there in data) (either row wise or column wise) is there any option to include that field in all pivots through single click. (Like we refresh all pivots through refresh all button)
Vikas Gupta
(Tax Executive)
(530 Points)
Replied 13 November 2014
veera
(searching)
(52 Points)
Replied 14 November 2014
| Originally posted by : Vikas Gupta | ||
 |
When you go to the sheet where you have created pivot table, you'll see 'Options' menu bar at the top. Choose this menu (i.e. 'Options')then choose refresh and click on refresh all. You'll get the updated pivot if any of the rows has been updated in data sheet. |
 |
Thanks Vikas for your info. but I mentioned this already (like we refresh all). My doubt is like we do refresh all can we do options chages for all pivots at once. Suppose if I want to include Grand toal for all pivots could I do this one single click (I know how to include grand total for a single pivot - how to do this for all pivots at once is doubt)
LIVE Course on Foreign Exchange Management Act (FEMA)(with recording)
LIVE Course on Foreign Exchange Management Act (FEMA)(without recording)
CAclubindia
