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

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