| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table question
I am running Excel 2003 but it still adds new projects :-(
"Don" wrote: Depending on the Version of Excel , but you should be able to select the drop down arrow next to the shaded field on your Pivot table and choose only the items you want to keep. This means that once you choose these and if a new items is added to your DB and you hit refresh, it should not add it to your pivot report. "Beverly Darvill" wrote: Hi I have spreadsheets that take data via a pivot table from an OLAP cube that is held on a terminal server. The spreadsheets hold figures entered by me and figures obtain from the pivot table. I want to enable the automatic update on the pivot table but the pivot table is sorted by a project number obtained from the OLAP cube. My problem is if a new project is added to the OLAP cube then it is automatically selected from the drop down list. I want to be able to turn this off so that it only selects the project I have previously chosed. For example if I have selected the filter number of 518 and a new project is added to the OLAP cube of ABC123 when a refresh of the data is enabled it will select both 518 and ABC123 and I want it to only select 518 on the refresh. How do I do it please. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Question | Excel Worksheet Functions | |||
| Pivot Table Question | Excel Worksheet Functions | |||
| Pivot table question | Excel Discussion (Misc queries) | |||
| Pivot table question | Excel Discussion (Misc queries) | |||
| Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
![Beverly Darvill[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
