Thanks JP,


Yes, when enter = and click on a grand total item for a company I get the "Full" formula
I then copy the formula to my summary page, add the sheet reference and replace any hardcoded criteria with cell references to
where the criteria are stored on the summary worksheet and add absolute references as appropriate.

Absolutley driving me insane, especially since a Getpivot formula works for PivotA.Form.Company
But as soon as I change to FormB the formula fails - all else equal

I have checked the name of the form at least 10 tiems no to make sure it is exactly the same as the Pivot (It is)
I copy pasted the the form from the Pivot Table to the summary worksheet
I have rebuilt the Pivot table - same result

Any other ideas?
Thanks
W