The Macro for refreshing the pivot table does not work on a Mac computer - Need Help

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

Please Login or Register  to view this content.

Please advice.

Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.