在excel中运行录制的宏时出现运行时错误

I did recorded some macros in excel and it was working perfectly till I did record a macro to creating a pivot table but after that I was facing "Run time error '5' invalid procedure call or argument" when I run this macro ! I tried to change the extension of the file to .xlsm but didn't work !!I did recorded some macros in excel and it was