| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to enable data option on a pivot table
Hi all,
when i use a pivot table with external data source (a cube or a perpective), i have two options unavailable (on the pivottable options, data tab) : Save source data with file Number of items to retain per field these two options are grey. How I can enable these two options ? thanks regards |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to enable data option on a pivot table
In short you can't. The pivot table is just an interface into the cube. When
you base a pivot table off of a cube you lose a bunch of functionallity. -- HTH... Jim Thomlinson "Phoenix" wrote: Hi all, when i use a pivot table with external data source (a cube or a perpective), i have two options unavailable (on the pivottable options, data tab) : Save source data with file Number of items to retain per field these two options are grey. How I can enable these two options ? thanks regards |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to enable data option on a pivot table
ok
thanks a lot for your support regards "Jim Thomlinson" wrote: In short you can't. The pivot table is just an interface into the cube. When you base a pivot table off of a cube you lose a bunch of functionallity. -- HTH... Jim Thomlinson "Phoenix" wrote: Hi all, when i use a pivot table with external data source (a cube or a perpective), i have two options unavailable (on the pivottable options, data tab) : Save source data with file Number of items to retain per field these two options are grey. How I can enable these two options ? thanks regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table option is grayed out | Excel Discussion (Misc queries) | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| Pivot Table Data Field Option | Excel Discussion (Misc queries) | |||
| if there an option allow me to appear the item in pivot table as . | Excel Discussion (Misc queries) | |||
| pivot table option is greyed out | Excel Worksheet Functions | |||
Linear Mode
