View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
phoenix phoenix is offline
external usenet poster
 
Posts: 6
Default 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