>Hi all, > > I'm able to show the pivot table in the Excel but why in the VFP, i still see an error "An Ole Automation Error occured. Your Excel pivot table may not be complete."? May i know what're the reasons that this error happens? > >Thanks. :)
Basically you received a COM return error from Excel. I would suggest you debug the program line by line while it is creating your pivot table and see which line gives you the error.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry