Bracket the fields that you are adding with a single quote '
Such as " = 'Rest & Breaks' + 'Driving Time' "
(I have added and removed some spaces to make it easier to see, not sure how
well the "program" will handle the "additional" quotes or if it will
understand that Driving Time is different than Driving Time

But should fix your problem.


"Geoff" wrote:

Hi,
I have 2 table titles in a spreadsheet, 'Rest & Breaks" and 'Driving
Time'. When creating a PivotTable I get :
.PivotFields("Rest & Breaks") and
.PivotFields("Driving Time")

These are ok but how do i create a calculated field adding the 2 values
together? The following line does not work:

.CalculatedFields.Add "Duty Time", "=Rest & Breaks + Driving Time", True

I believe it is the '&' in Rest & Breaks which is the problem.

How can I get round this please without altering the titles.

T.I.A.

Geoff