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.
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
Bookmarks