Hi,
Based on the error message: "Run-time error '5': Invalid procedure call or argument", this issue is usually caused by the Excel macro or add-ins.
Have you installed some Excel add-in or add some macros to Personal Macro Workbook recently?
I recommend we start Excel in
safe mode, if the error disappear, please try to do the 2 steps:
1. Go to File>Option> Add-ins> Disable/check them one by one
2. Check the
Personal Macro Workbook, location:
C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART
Then, if this issue still exists, please try to
repair Office.
Hope it's helpful.
Regards,
George Zhao
TechNet Community Support