View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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