Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable - Clear all data fields
Hi,
I've created a PivotTable which uses control buttons to tigger a macro that selects which Report Filters, Row Labels and Values to select for a particular 'view'. There are three of these buttons / macros and this works ok. When someone selects another 'view' by pressing a different button, I have to use the following code to clear the Pivot (otherwise the Pivot will display the existing fields as well as the new ones): ActiveSheet.PivotTables("Central").ClearTable This is fine - except by using ClearTable I lose any field formats (eg. £ in the Value fields) and the Pivot automatically applies Subtotals to every field again. IS there any way of clearing all the currently selected fields without using the ClearTable function (so that my formatting remains)? Really appreciate any help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLear Data Entry Form Fields | Excel Discussion (Misc queries) | |||
A Fix - Pivottable - Added calculated fields and now can't clear pivot | Excel Programming | |||
Pivottable - Added calculated fields and now can't clear pivot | Excel Programming | |||
PivotTable - Unchecking and re-checking data fields | Excel Discussion (Misc queries) | |||
How to replace PivotTable data fields...? | Excel Programming |