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)
Menu
Excel pivot related doubt
Replies (2)
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.
| 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 :
- Rule 86(B) Applicability
- ROC FILINGS FY2025-26
- Mismatch in 26AS
- How Can a Trader Utilise Approximately ₹1.20
- How Can Law Students Present Papers at Conferences
- On which amount 200% penalty under section 270A is
- RECEIVED INTIMATION U/S 399 FOR TDS PAYMENT ON PRO
- How do CA firms track SEBI/AMFI circulars and dead
- Jurisdictional validity of Sec 148 notice after fa
- Taxable Income or Not
Related Topics :
CAclubindia
