Hi,

My excel pivot table is connected to Analysis Services Cube. However, I can
see that if i'm connected to AS cube, the Formulas menu in Pivot Table Tools
Options is disabled. Thus, I can't create an external formula, apart from
what I have in the cube.

I tried also creating a pivot table in which the data source is an excel
sheet. The Formulas menu is enabled and I can create a calculated field.

Why is it if I'm connected in Analysis Cube that it is disabled? Anything I
missed out to do?

Thanks a lot....