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 |