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

If you can't click on cells in your Excel workbook, try reopening the workbook or click on another window and then back to Excel; if that doesn't work, follow these methods.

How can I change part of an array in Excel? To edit an array formula in Excel, click on the cell containing an array formula and then select the formula bar present at the top.