Calculated Field in Pivot Table

[Analyze_This]

I'm trying to insert a calculated field into a pivot table and I'm having A LOT of trouble. Everything I read says to just click on the pivot table and the Pivot Table Tools tabs appear (excel 2007). No problem so far. Now you're supposed to click on the "Options" tab. Again, no problem.

From here you are supposed to select the "Formulas" option. But it's ALWAYS greyed out. No matter where I click on the pivot table or the PivotTable Field list, it's always greyed out. Any help...anybody?

 

[sr12345]

Have you checked for the worksheet being protected?

 

[Analyze_This]

I created the worksheet, so no. It's not protected.

 

[Analyze_This]

Sorry. It's connected to a data cube and I don't think you can add fields if the data is pre-crunched. Looks like I'm SOL with this one.