I just typed an Xlookup formula into a cell in my workbook, which I've done many times without issue. This time however when I hit enter on that formula, it opens vba editor and the references message box where you can check to add references for your vba project comes up. Inside that box there is a line item that is checked and it reads MISSING: NucleusNativeMessagingLib.
I've never seen the aforementioned library and I wouldn't have even known to select it as a reference. My formula I was typing into Excel looks like this but there isn't anything wrong with it and is pretty standard lookup, =XLOOKUP([@[HGT_inches]],Table1[Height],Table1[Score],"Missing",0)
Actually I just checked and I cannot enter any formula into any cell without producing the aforementioned error. In fact I can click into a blank cell and hit enter and it produces that error.
I closed out of my excel files and restarted them but they are still doing the same thing. I restarted my computer and opened them back up with same result. I did a quick repair of office, opened my files and same result.
I can't find anything about this error online really as I've been searching since yesterday. Does anyone know what this is or how I can fix it? If this is a situation where I can fix by doing a reinstall of office that is no problem. Any help or feedback would be greatly appreciated.
Thank you, Rayburn
Bookmarks