G Guest Oct 26, 2006 #1 I want to keep changes to format i performed in a pivot chart, that would not be affected upon refresh table. thanks\
I want to keep changes to format i performed in a pivot chart, that would not be affected upon refresh table. thanks\
A Andy Pope Oct 26, 2006 #2 This is a known bug that requires vba code to re-apply formatting. XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 Cheers Andy
This is a known bug that requires vba code to re-apply formatting. XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 Cheers Andy
G Guest Oct 26, 2006 #3 thanks Andy, does MS supply any add-in for or just record it on my local report? thanks
A Andy Pope Oct 26, 2006 #4 Use the macro recorder to capture the formatting commands. Here is a great resource for all things pivot tablely! http://www.contextures.com/xlfaqPivot.html Cheers Andy
Use the macro recorder to capture the formatting commands. Here is a great resource for all things pivot tablely! http://www.contextures.com/xlfaqPivot.html Cheers Andy
