Can you please post your code so we can have a look at it, and also,
highlight the line that causes the error.

It may just be that the code is not referencing the worksheet...so it can't
find the pivot table

Philip

"Rossy" wrote:

I'm working on macros.
I've build a spreadsheet and then I press the register new macro button ..I
registered the macro that built a pivot table in a new spreadsheet..
I pressed end registration...and saved the macro.
I closed the file without saving .
I reopened the file and execute the macro.Then I got the error.
Impossible to find the property PivotFields for the PivotTableClass.
How can I solve this?