search

microsoft / advanced-formula-environment

Create, edit, and reuse formulas in Excel
https://aka.ms/get-afe
MIT License
109 stars 11 forks source link

Excel Labs fails to load #68

Open Michelle39140 opened 8 months ago

Michelle39140 commented 8 months ago

I installed Excel Labs from Add-ins store, but it won't load for me. Tried re-loading multiple times but it doesn't work.

My office version if Version 16.77 (23091003). MacOS is Ventura, Version 13.5.1.

image
jack-williams commented 8 months ago

Are you able to open the developer tools and check the console for any error messages? This might help us track down the problem.

To do so, I think you need to run

defaults write com.microsoft.Excel OfficeWebAddinDeveloperExtras -bool true

as described here: https://learn.microsoft.com/en-us/office/dev/add-ins/testing/debug-office-add-ins-on-ipad-and-mac#debugging-with-safari-web-inspector-on-a-mac

and then you should be able to right-click, inspect element, and then view console.

If you are unable to do that. Do you know if this happens in every workbook, even blank ones? Do the other 'experiments' like the generative ai and python panes also fail to load?

NickRedwood commented 6 months ago

I regularly get this error too, seems to be more common with a complex workbook so possibly a time-out? I used inspect element and get the following screen, let me know if you want me to provide more details @jack-williams .

image

NickRedwood commented 6 months ago

I also find Excel Labs can spend a long time on 'Loading data from your workbook' before it fails. Also, if I click in a cell while it's doing this, it goes to the 'Failed to Load' screen and then refuses to try again if I click Retry.