Forum Discussion
Excel Labs : Grid editor open and stay blank
Hie,
I have juste installed Excel Lab on my machine : Microsoft® Excel® LTSC MSO (16.0.14334.20688) 64 bits
And i have never seen anything in the Grid editor.
5 Replies
- Gilles_53Copper Contributor
Hi Nicolino and SergeiBaklan,
Thanks for the analyse.
I joined the debbuger as suggested in the menu functions and it shows these messages in loop in the consol tab :
taskpane.2c4b4cd292f…b3f683e.bundle.js:2 External code service environment data read failed: RichApi.Error: Nous n’avons pas pu trouver l’API que vous essayez d’utiliser. Elle peut être disponible dans une version plus récente d’Excel. Veuillez vous référer à la documentation : « https://docs.microsoft.com/office/dev/add-ins/reference/requirement-sets/excel-api-requirement-sets ». at new n (excel-win32-16.01.js:26:273020) at i.processRequestExecutorResponseMessage (excel-win32-16.01.js:26:338426) at excel-win32-16.01.js:26:336486 at async taskpane.2c4b4cd292f…bundle.js:2:8008233 at async taskpane.2c4b4cd292f…bundle.js:2:8008104 at async t.CoalescingJobQueue.onRun (taskpane.2c4b4cd292f…bundle.js:2:8008041) taskpane.2c4b4cd292f…b3f683e.bundle.js:2 Error reading cell data (sheetId={8F5197BB-09D7-4AC6-9739-AB80D4CF0C29}, values=M13:O15, formulas=M13:O15, blanks=M13:O15): RichApi.Error: La propriété « valuesAsJson » n’est pas disponible. Avant de lire la valeur de la propriété, appelez la méthode de chargement sur l’objet conteneur et appelez « context.sync() » sur le contexte de demande associé. at new n (excel-win32-16.01.js:26:273020) at n.createPropertyNotLoadedException (excel-win32-16.01.js:26:376486) at n.throwIfNotLoaded (excel-win32-16.01.js:26:376229) at r.get [as valuesAsJson] (excel-win32-16.01.js:26:386878) at taskpane.2c4b4cd292f…bundle.js:2:7997401 at E (taskpane.2c4b4cd292f…bundle.js:2:7997799) at taskpane.2c4b4cd292f…bundle.js:2:8003900 at async t.CoalescingJobQueue.onRun (taskpane.2c4b4cd292f…bundle.js:2:7999438)It seems indicating to me that an Excel API fonction is missing !
- SergeiBaklanDiamond Contributor
I guess that's Excel 2021. If so Excel Labs shall work with it. At least AFE, not sure about other components. If right pane is blank that could be issue with internet connection (settings, firewall). Also clean of Office cache could help. Or simple restart.
- NikolinoDEPlatinum Contributor
Based on what I have been able to see and research, Excel LTSC 16.0 with a build number in the 14334.x range corresponds to the initial release of Office LTSC 2021 (the perpetual license version released in October 2021), judging by the number the user provided.
https://learn.microsoft.com/en-us/officeupdates/update-history-office-2021
- SergeiBaklanDiamond Contributor
Thanks for the clarification. AFE works with any Excel starting from Excel 2016. If we speak about AFE, not LABS.GENERATIVEAI and Python Editor.
- NikolinoDEPlatinum Contributor
Based on the version details you provided (Excel LTSC 16.0.14334.20688), it is highly likely that you are facing an incompatibility issue with the Grid Editor, but it is difficult to claim this with 100% certainty without official documentation from Microsoft.