| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need to clear data references in pivot table report
I have a sheet that records registration data. It is supported by different
Pivot Table reports. The data in the main sheet changes twice a year and I need to find a way to clear the references that the reports use (as in 'show all', 'blank', etc.). I can clear the data from the main sheet, but the reports hold the data references. It is not affecting the reports functioning, it is just creating a HUGE reference list. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
| Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
| Pivot Table Source Data | New Users to Excel | |||
| Pivot Table not valid error message when formatting data 'button'. | Excel Discussion (Misc queries) | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
Threaded Mode
