I'm helping a colleague fix a spreadsheet with a similar issue as stated in this ozgrid post.

**The problem:** Pivot table with 31 calculated fields. Some calculated fields are calculations of the source data while others are **calculations of the results of other calculated fields (this is the problematic part)**.

**Example and the only workaround I have so far**:

`Total Sales $ TY`

`='Chain Sales Dlrs TY'+'WTD Sales TY'`

`Total LY Sales $`

`='Chain Sales Dlrs LY'+'WTD Sales LY'`

`Chg Sales $`

`='Total Sales $ TY'-'Total LY Sales $'`

** Total Sales $ TY** and

**use data source values,**

`Total LY Sales $`

**uses the results of**

`Chg Sales $`

**and**

`Total Sales $ TY`

**to calculate change. On changing the data source (e.g. changing values, column headings, insert columns, etc.),**

`Total LY Sales $`

**will give a**

`Chg Sales $`

**error on refresh. If I change**

`#NAME?`

**to be a formula using data source references (i.e.**

`Chg Sales $`

`=('Chain Sales Dlrs TY'+'WTD Sales TY')-('Chain Sales Dlrs LY'+'WTD Sales LY')`

), it works, but there are 20-30 of these to change.Is there a way to use results of calculated fields in a calculated field and still have it refresh correctly in **Excel 2010**?

`#NAME?`

error on`Chg Sales $`

. To fix this, think I'd start by looking to rebuild the file/pivot table from scratch in a new workbook (if that isn't too big/scary a job!) – Andi Mohr Dec 19 '14 at 13:44