Error: Office.js has not fully loaded. Your app must call "Office.onReady()" as part of it's loading sequence

Question

I have created an Excel add-in using the Office JS library. My add-in works fine with Office 365 but when try to run the same add-in with Office 2019 or 2016 it shows a blank screen only and throws error : Office.js has not fully loaded. Your app must call "Office.onReady()" as part of it's loading sequence (or set the "Office.initialize" function). If your app has this functionality, try reloading this page.

In some GitHub issues, they are saying that Internet Explorer 11 doesn't understand ES6. I have tried converting all arrow functions to normal functions and added target as ES6 in tsconfig also.

Please give any solution for how to run the add-in with all the Office versions.

How does your code look like for the task pane? Have you tried creating a new sample add-in with a task pane and run it there? Does it work correctly? — Eugene Astafiev, Jul 03 '23 at 13:10

score 0 · Answer 1 · answered Jul 03 '23 at 13:03

0

Office Add-in cannot successfully call any Office JavaScript APIs until the library has been loaded. Initialize your Office Add-in article describes the two ways your code can ensure that the library has been loaded:

Initialize with Office.onReady().
Initialize with Office.initialize.

Make sure you have defined any of them in your add-in.

answered Jul 03 '23 at 13:03

Eugene Astafiev

47,483
3
24
45

I have defined both of them but it's not working. – Poojan3037 Jul 03 '23 at 13:08
There is no need to define both of them. Only one of them should be used in the code. – Eugene Astafiev Jul 03 '23 at 13:09
Yes, I just tried the all scenarios. Currently, I am only using Office.onReady() as below Office.onReady(() => { isOfficeInitialized = true; render(App); }); – Poojan3037 Jul 03 '23 at 13:13
It's working on office 365 but with office 2016 and 2019 not working – Poojan3037 Jul 03 '23 at 13:14
I suppose you are using some engines for the task pane like React or Angular and earlier versions of the web browser can't render it, am I correct? – Eugene Astafiev Jul 03 '23 at 13:18
Yes, you are correct. I am using React and the earlier version of the web browsers (IE 11) can't render it. Can you suggest to me whether it is possible or not to render the task pane on an old browser with React? – Poojan3037 Jul 03 '23 at 13:20
Does it work if you try a standalone application with your app in that browser version? – Eugene Astafiev Jul 03 '23 at 13:26
No it's working on IE11 but working fine on the Edge. – Poojan3037 Jul 03 '23 at 13:30
So, the problem is with your application, not related to Office web add-ins, correct? – Eugene Astafiev Jul 03 '23 at 13:35

Error: Office.js has not fully loaded. Your app must call "Office.onReady()" as part of it's loading sequence

1 Answers1