Excel pivot related doubt

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)