Hi,

I am reading a pivot table from xls file into my VBA code and peforming some calculations based upon the same.

In the Pivot table, I have one of the fields which is not added to the pivot report. This field is required by me in the calculations. When I refer to this field in the VBA code, I am unable to get the value from the same and get an error : Application or Object Undefined

When I manually add the field to the pivot report in the xls file and run the same VBA code, it works fine.

Is there a way to programatically control the adding of this required field to the pivot report temporarily as I do not have the control of the xls file and can't make any permanent changes to the file.

Thanks in advance.

Shantanu Kulkarni