Title:
Change All Pivot Tables When One Changes
Video:
Description:www.contextures.com Instead of changing multiple pivot tables individually, add this Excel VBA code to your worksheets, so all the pivot tables change automatically, if one is changed. Designed for Excel 2007 and Excel 2010 workbook, the code also changes the "Multiple Item Selection" settings to match changed page fields. Download the sample file from the Contextures website: www.contextures.com (PT0025 - Change All Page Fields with Multiple Selection Settings), and copy the sample code into your workbooks.
Published:
03/Jan/2012
Change All Pivot Tables When One Changes
Video:
Description:www.contextures.com Instead of changing multiple pivot tables individually, add this Excel VBA code to your worksheets, so all the pivot tables change automatically, if one is changed. Designed for Excel 2007 and Excel 2010 workbook, the code also changes the "Multiple Item Selection" settings to match changed page fields. Download the sample file from the Contextures website: www.contextures.com (PT0025 - Change All Page Fields with Multiple Selection Settings), and copy the sample code into your workbooks.
Published:
03/Jan/2012
No comments:
Post a Comment