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?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,509 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,645 questions
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viki Ji_MSFT 4,421 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
  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
  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.