Lots of #BUSY! errors

Laptop User 1 Reputation point
2021-08-13T01:24:31.277+00:00

I have an Add-in that I've developed for Excel online and Excel 2016 (e.g. a JavaScript add-in). It's worked fine up until last week. A lot of users have been complaining that they see #BUSY! when they try to use my custom formula. Sometimes, if they uninstall and reinstall the Add-in and close/reopen Excel it will work. In the online version of Excel I get a prompt everytime I open my sheet to click a button to "Trust this add-in". I haven't made any changes to the add-in for months and no reason on our end for this to occur. Was there an update on Excel's end that needs to be rolled back?

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Viki Ji_MSFT 4,471 Reputation points
    2021-08-13T07:52:32.98+00:00

    @Laptop User ,
    Welcome to Q&A forum!

    According to your description, this issue is related to third-party Add-ins that is not supported in Q&A currently.
    Thanks for your understanding!

    Personally, I found the following official articles about the error #BUSY, pelase check them out.
    Troubleshoot custom functions
    How to correct a #BUSY! error

    Hope the information is helpful to you.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Laptop User 1 Reputation point
    2021-08-13T09:41:12.213+00:00

    To the contrary: this is clearly an issue with an Excel update since we haven't made any updates for quite some time. The fact that I have to manually click a button to trust the Add-in everytime I use it at office.com and that you get different behavior on desktop makes it clear it is a problem with Excel and not the add-in.

    0 comments No comments

  3. Laptop User 1 Reputation point
    2021-08-13T10:09:44.847+00:00

    I should add that on the desktop version the issue is fixed if the users uninstalls the add-in, installs it again and restarts excel. So, the problem is not with the add-in itself.


  4. Laptop User 1 Reputation point
    2021-08-16T17:15:21.933+00:00

    How do we update the version for the web?


  5. Laptop User 1 Reputation point
    2021-08-19T21:34:21.147+00:00

    Now we have users reporting "This add-in is no longer supported on this application". They are using Excel version 2019.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.