| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i elmininate old data from Report filter on pivot table?
I need to show on the report fields of pivot table only de data that are on
DB, if a new information change on DB i need to refresh on pivot table, not only values, besides the data. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i elmininate old data from Report filter on pivot table?
In Excel 2007, right-click on a cell in the pivot table
Click PivotTable Options In the dialog box, click the Data tab From the Number of Items to Retain Per Field dropdown, choose None Click OK Refresh the pivot table Santiago wrote: I need to show on the report fields of pivot table only de data that are on DB, if a new information change on DB i need to refresh on pivot table, not only values, besides the data. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table - Sort Report Filter Values | Excel Discussion (Misc queries) | |||
| Pivot table report filter problem | Excel Discussion (Misc queries) | |||
| Report choosing a Pivot table data | Excel Worksheet Functions | |||
| how do I format data into columns using a pivot table report? | Excel Discussion (Misc queries) | |||
| need to clear data references in pivot table report | Charts and Charting in Excel | |||
![Santiago[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
