For details on how to do this, see this Microsoft support article. If you see the error "We can't open this add-in from localhost," you will need to enable a local loopback exemption. Common problems and solutions Can't open add-in from localhost: Use a local loopback exemption For more information, see Clear the Office cache. You can fix this by clearing the Office cache. Sometimes while developing and repeatedly reloading an add-in with custom functions your changes may not appear. Information about custom functions is cached by Office. A #REF! error may indicate that your function name is the same as a function name in an add-in that already exists.A #VALUE error typically indicates an error in the functions' script file.This is typically due to a missing CustomFunctions.associate command. A #N/A error is also maybe a sign that that function while registered could not be run.A #NAME error generally means there has been an issue registering your functions.The are only a few exceptions specific to custom functions, listed here: Generally, these errors correspond to the errors you might already be familiar with in Excel. Custom functions only use the following error messages: #NULL!, #DIV/0!, #VALUE!, #REF!, #NAME?, #NUM!, #N/A, and #BUSY!. Check for Excel error messagesĮxcel has a number of built-in error messages which are returned to a cell if there is calculation error. For more information about runtime logging, see Debug your add-in with runtime logging. The statements cover a variety of errors, including errors pertaining to your add-in's XML manifest file, runtime conditions, or installation of your custom functions. Runtime logging delivers console.log statements to a separate log file you create to help you uncover issues. If you're testing your add-in in Office on Windows, you should enable runtime logging. Also, check for common mistakes such as leaving promises unresolved. To resolve issues, you can enable runtime logging to capture errors and refer to Excel's native error messages. Note that Excel custom functions are available on the following platforms.Įxcel custom functions are currently not supported on iPad or in one-time purchase versions of Office 2019 or earlier.
0 kommentar(er)
