Pivot-Table Auto Update Macro

Hi there, I'm running into problem with a macro that I got from a website: http://www.cpearson.com/excel/pivots.htm

It works fine for the pivot table but since I'm having a Dynamic Database, everytime my data changes in length; it always popped up with this error:

"Run time error 1004: The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled coloumns. If you are changing the name of a PivotTable field, you must type a new name for the field."

When I go run debug, one of the code was highlighted in yellow as you can see below.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any suggestion on how to fix the problem? I'm not an expert in VBA, if somebody have time please explain to me what each line does.

Thanks heaps

Try

Please Login or Register  to view this content.

Also, Auto_Open macros were superceded by the Workbook_Open event

no errors for me, have you got PivotTables on the Activesheet?

The code refers to the Activesheet, the one currently in use when the code is run. If it has no PivotTables the code will fail. Try specifying the correct sheet

Please Login or Register  to view this content.