Refreshing pivot table macro does not work on a Mac computer.

I have the following code in excel 2007 (works fine on Windows computer), but does not work on a Mac (excel 2011).

Please Login or Register  to view this content.

Please help.

Hello Moo,

Yes, you are right. I have the pivot in the dashboard and data is being pulled from the "Data" sheet.

And, the code is placed in the "Data" sheet itself

Try using worksheet change events instead

AB33, I did not get your point. Please explain

Try this code in your data sheet(Source sheet)

Please Login or Register  to view this content.

Thanks. I will try this once I am back to my office. Will reply then.

Hey, the code that you gave worked!!!

I appreciate your help