Share via

What does this error mean and how do I fix it?

Anonymous
2015-10-16T01:24:52+00:00

What does this mean and how do I fix it?

Microsoft Visual Basic

Run-Time error '5':

Invalid procedure call or argument

It started this morning with excel files with macros

I have spent the entire day trying to get someone at Microsoft support.  At the end someone told me that I have to pay for support to get this fixed.  This is Office for Mac that I just purchased last Friday. 

Extremely frustrated and pissed off.  I need to get back to work and not chase MS support.

PLEASE HELP!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-12-15T08:17:23+00:00

    Hi,

    I have Office 2016 for Mac.

    After I upgraded to OS X High Sierra, I updated Office as well. I'm now facing the below message every time I launch Excel. (I'm not even opening a specific workbook, just opening Excel)

    Run-time error '5':

    Invalid procedure call or argument

    The Debug button is grayed out (as is the Continue button), and the only way I'm able to start my work is to hit the End button.

    I've disabled all add-ins, ensured all available updates have been applied, and I'm still facing the same problem. Would appreciate any suggestions on how to fix it.

    Vikram

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2015-10-20T18:31:09+00:00

    Because Apple imposed "sandboxing" requirements on Microsoft Office some commands no longer work. The error message "

    Invalid procedure call or argument (Error 5)" is pretty general. If you would troubleshoot the code and copy the code which is generating the error and paste that code here we might be able to explain why it works in 2011 but not 2016 and what could be done to make the code work, or why your code will never work in 2016.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2015-10-16T12:18:04+00:00

    That means that a macro in the file you are trying to open is making an invalid call. did the file work before "this morning"? If so, what changed?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2015-10-28T23:03:57+00:00

    How do I do that?

    Was this answer helpful?

    0 comments
  5. Anonymous
    2015-10-19T00:57:09+00:00

    Yes it was working.  I have never had a problem with this on my 2011 Office and didn't have the problem since Friday of last week when I upgraded to Office 2016.  I spent 10 hours trying to get support from Microsoft.  It was HELL!!!

    At the end they told me that I have to pay $499 for advanced support.  That basically did it for me. 

    I am still having the problem on 2016 but not 2011.  Microsoft support has been worthless on this.

    Was this answer helpful?

    0 comments