I 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)
2 Replies
Vikas Gupta
(Tax Executive)
(530 Points)
Replied 13 November 2014
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.
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)
Recent Topics
- Nznxnc call me at the end of the day of the
- Cp chod doob zoom vo book book
- Nsje snswk fjw ed le ene djff ne enje ejdd rejje
- Hxjcif the day I have been in touch with me and
- Iska djd djrbdsjebshe sir ur rei ejr reinr the jr
- GST registration for medical shop in Karnataka
- Hsshs me know if you are free number of the
- Chu Kang and the situation of the situation and I
- How to reverse wrong transaction payment in phonep
- Paytm wrong transaction
Related Threads
CAclubindia
