OfficeDev
ProductSearch sample function fails to run
Bug Report
- Host: EXCEL
- OS: Windows 11 23H2; 22631.2048
- Browser: Edge production
- Environment: Production
Expected behavior:
Script lab doesn't give errors
Actual behavior:
Formula results in a #BUSY! error that never resolves; flashes a dozen+ times, and scriptlab shows "add-in error" business bar
Steps to Reproduce:
- Open Excel; install scriptlab addin; new blank workbook
- Search samples for "data types: custom functions"; open that sample
- Register that sample
- As described in the samples' code / instructions, paste this into an arbitrary cell in your spreadsheet:
- =SCRIPTLAB.DATATYPESCUSTOMFUNCTIONS.PRODUCTSEARCH("chef", false)
Expect: Script to run, show results Actual: See persistent #BUSY! error that flickers a number of times, and "Add-in error" message shows up within scriptlab. Clicking "restart" in the business bar causes it to dismiss very briefly, then show up again.
Failure Logs:
No failure messages are shown in scriptlab's console.
Screenshot:
This also seems to leave Excel in a "trying to figure something out" state, as I can see through task manager that it's chewing up a lot of CPU after inserting that method that is failing to resolve.
Same problem for me - different script different function, same error.
The code loads and is perfectly fine (unchanged from the code I was using the last few weeks), but the add-in just doesn't start. Have tried even basic scripts from the gitlabs library, problem definitely with Excel or the Script Lab add-in. Seems one of them changed / background updated in the last 24 hours.
Yeah, I've tried office 2016 and 365. It gives the same error "Add-in Error: This add-in could not be started."
On Excel 365 Windows on various machines) samples for all "custom functions" (which used to work before) now give 'ADD-IN ERROR This add-in could not be started. Close this dialog to ignore the problem or click "Restart" to try again' or even without the above message permanently display "#BUSY!" as a result. No suggestions including updating, repairing, reinstalling Office, not even after running as admin 'powershell Add-AppxPackage -register -disable c:\windows\SystemApps\Microsoft.Win32WebViewHost_cw5n1h2txyewy\AppxManifest.xml', not even repairing/reinstalling WebView2 helped at all and custom function samples from the Script Lab add-in all fail with the same error.
Excel 365 on MacOSX runs Script Lab sample custom functions perfectly as before.
Hi,
This is similar to the following issue: https://github.com/OfficeDev/script-lab/issues/1014
I am encountering the exact same issue with Excel and Script Lab 😔
Here are my details:
- Operating system: Windows 10 Professional, build 19045.3208
- Excel: Microsoft® Excel® for Microsoft 365 MSO (Version 2307 Build 16.0.16626.20170) 64-bit
The same problem exists for me. The add-in works for regular code snippets, but even the simplest custom functions fail.
Excel: version 2310 (build 16924.20106)
