Pivot Table and Cell references

[NX555V]

Hello

Thanks in advance.

When I create a formula and reference a cell within a pivot table and then drag that formula down a column or row - it does not automatically adjust for the next cell down or across. It continues to reference the initial cell.

Is there a way around this?

 

[Gerald Higgins]

I'm guessing that you are writing this formula by using the cursor to select the cell in the pivot table - am I right ?

One way round this is not to do that, but to type the cell reference in directly to the formula.
For example, if C2 is the cell in the pivot table that you want to refer to, write C2 directly into the formula.

 

[NX555V]

Thanks I have done that, thought maybe there was another way. Thanks again