The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Absolute cell reference: There may be times when you do not want a cell reference to change when filling cells – for example, referring to a % price increase. Unlike relative references ...

You may be well-accustomed to using cell references in Excel, but did you know you could go one step further and create your own cell references? This is where the INDIRECT function comes in handy.