Cube & Pivot in Excel

[kingz2000]

Hello again,

I am usind a cube-datasource on a pivot table. due to the complication of one of the field, I am having to remove it from the pivottable and inserting it again, using "cubefields".

'remove field
p.CubeFields("[ReCube Date Dimension].[Booking Periods]").Orientation = xlHidden
'add field
p.CubeFields("[ReCube Date Dimension].[Booking Periods]").Orientation = xlPageField
p.CubeFields("[ReCube Date Dimension].[Booking Periods]").Position = 17


That is the 1st part and works well..However when I want to select from this Pivot-field
p.RefreshTable

If intOpt = 1 Then
p.PivotFields("[ReCube Date Dimension].[Booking Periods]").CurrentPageName = _
"[ReCube Date Dimension].[Booking Periods].&[" & strString1 & "]"

I get an error reading "The Item could not be found in the OLAP Cube"!
I need to use pivotfield in order to get the method ".currentpagename",right??

Or are there other soutions?

Thanks in advance.

 

[kingz2000]

please help...


any ideas??????