When york with powerpivot or excel pivota table you have Always the same problem:
“i want to refer to a scecific cell in a pivot table without creating the string connection to the cell”
We have two different solution to resolve the problem:
the problem can be resumed by this image:
I select one specific cell and then i have this lformula as the result
The first solution si very stupid, we can resolve our proble writing the exactly reference to the cell or selecting Other cell and after that moving on it.
This solution works only in current workbook, in every new worbook you owe it to redo again. But you have to do it one time and work more easily:
- Create a new pivot table you work book
- Select you pivot table
- Select design Tab on excel
- Select Pivot table Button
- Select the small head Arrow near option
- Deflag Generate GetPivotData
You can see the step me in this image
Now you can select all cells of every new pivot table in your workbook without creating formula references.