Editing a calculated field in Excel 2010 (compatibility mode)

[dleslieca]

How do you edit calculated fields in Excel 2010 running in compatibility mode? I put out a weekly report with lots of "moving parts" and fields that get updated weekly, including a pivot table that compares year-over-year data. This pivot table has three columns of calculated fields.

In updating the report from 2011 vs 2012 to 2012 vs 2013, the cell references in my calculated fields were changed, and now they either generate wrong data or have the "#NAME?" error message because the name of one of the columns used was changed. I cannot figure out how to simply modify the calculated field's formula, and I prefer to not have to delete and recreate the fields. Any suggestions?

FYI, this is being done in compatibility mode because the report was originally created in Excel 2003, which is still used by some of the report recipients, so conversion is not yet an option.

Thank you!
David

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[dleslieca]

I did figure this out after playing around a little longer. To edit a calculated field, go to PivotTable Tools/Fields,Items, & Sets (MS's punctuation, not mine). Select "Calculated Field". The "Insert Calculated Field" window opens, but the "Name:" field has a drop-down list of current calculated fields. Select the field you wish to edit, and from there it's more or less the same as creating a new one.