xll got auto-opened in Excel UI

Excel-DNA / IntelliSense

Add in-sheet IntelliSense for Excel UDFs

MIT License

170 stars 52 forks source link

xll got auto-opened in Excel UI #108

Open 4R3B3LatH34R7 opened 2 years ago

4R3B3LatH34R7 commented 2 years ago

Office365 Excel 64bit with Excel-DNA Intellisense 1.4.2.xll, Win10 64bit. Unblocked already in C: users addins directory. When .xlsm was opened, xll was auto-opened as readonly in UI as well, with every xlsx and xlsm. Cannot uncheck the addin from Developer - Addins menu. Had to manually delete the .xll. Error message as shown in attached photo. excel-dna intellisense error message .xll got auto opened as shown in attached photo. excel-dna intellisense auto opened

govert commented 2 years ago

That error message normally means that you are opening the 64-bit version of the add-in in a 32-bit installation of Excel (or vice versa).

govert commented 2 years ago

Maybe you can show a screenshot of the Excel version (File -> Account -> About Excel). I have this:

4R3B3LatH34R7 commented 2 years ago

Yes, you are right, my user was quite adamant that her Office365 was 64bit. Problem was solved by using 32bit xll.

The only issue left was: if .xlsm(containing Intellisense worksheet) was double clicked to open, the Intellisense doesn't work for UDF and needs to close the file from File menu then open .xlsm again to get Intellisense working. However, if Excel were run first, then open .xlsm from recent list, Intellisense kicked in immediately. Excel-DNA Intellisense host was checked in Developer-Addins in both scenarios. Thank you.