Excel crash while setting formula parameters

Question

Carefully worded: I have a UDF that I have used for years, modifying it every so often as improvements are made. Lately (last year or so), when I am using the function and entering one of its range parameters, and if the input it as a reference to another workbook, then immediately upon clicking on the range, Excel will occasionally hang and then crash. There are no other addins and no other conditions under which it crashes. The workbooks are not large, and the crash seems to be unreliable (although if it "passes" once I can use the function all session and it seems to work fine...and it doesn't seem to matter if the add-in is loaded ahead of time). The function itself doesn't seem to execute (breaks don't trigger), especially since I'm not hitting enter yet (just setting up the inputs via clicking and the comma key between parameters). I have no other crashes other than if I load too many massive files, and it is only hitting this one function under these specific circumstances. Help! :'(

Answer 1

There are no otheraddins                

Inferring from this statement that the UDF code is stored in an add-in. Do you also get crashes if the code is pasted into a local module within the current workbook, and /all/ add-ins are disabled?

Also, it might be helpful for you to paste the UDF code into this thread, in case there are syntax issues the other forum users might notice. If you recall which code changes have been made since the last stable version, you might call those out as well (for example, bold or italics those code blocks)

Has this issue been replicated on any other machines?

Answer 2

Hi,

Add-ins can interfere the functionality of the application could be possible reasons why your Excel 2013 crashed occasionally. To resolve this concern, we suggest that you open the application in safe mode and disable the add-ins from there. To do this, follow the steps below:

1. Press the Windows key and R on the keyboard.
2. In the Run command, type excel /safe and click OK.
3. Go to File, select Options and click Add-ins in the left corner.
4. In Add-ins page, change the Manage to COM Add-ins and click Go.
5. Uncheck all available add-ins and click OK.
6. Relaunch Excel and check if the issue still persists.

In the event that it doesn’t work, we recommend that you download to run our Microsoft Office Configuration Analyzer Tool to diagnose the concern and to give you a list of the possible fixes. To get more information about this tool you may want to give this link a read.

Let us know if you need further assistance.