View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stan Michel Stan Michel is offline
external usenet poster
 
Posts: 1
Default Pivot Page field value not shown

I created an worksheet with several pivots. There is a parameter screen to
define parameter and these parameter will be defaulted to all pivots.
I realize that the defined parameter (e.g. Year 2007) is not available in
the pivot page field. It is shown as a blank string.
It looks like this
2005
2006
[]
2008
The result is fine for 2007. But it is confusing.

Any ideas how to fix it ?

Thanks and regards
Stan