Using PivotTable data in a formula

When you create a formula, it's usually a good idea to draw the formula's values…from the original data source.…That way if the source changes, your formulas result will update the next time…Excel recalculates your workbook.…But what you do if your PivotTable contains data drawn from an outside source…and you can't get at the original tables?…In that case you can refer to a cell within the PivotTable using a GetPivotData formula.…Let's say that you want to use the data in a PivotTable cell in your…formula and for that we will make it the value in C6, which is the value…for January 2009 for FirmB.…

To create this formula, you start typing another formula such as Sum, so click…any cell outside the PivotTable and then type equal and then name of the…function, Sum, and then a left parenthesis and now you click the cell that you…want to use the data from inside the PivotTable.…So in this case I will click cell C6 and you see that Excel creates a GetPivotData function, …which has a bunch of information inside of it.…