Unable to install on MS 365 Apps for enterprise

[RaenonX]

I am using Office 365 because my school account has it. The plugin I tried to install is for Excel.

Despite I ran ExcelSetup.msi and it says "successfully installed," nothing popped up for me to enter the API key.

• I reran the msi file, and it gives the repairing and removing options, which I think it's an indicator that the system considers it as installed.

I tried to manually install the plugin via the Excel settings, but it gives not a valid add-in.

• Via Options > Add-ins > Manage > COM Add-ins

[yihuajack]

Same problem on Microsoft Office 2019 and Microsoft 365 Family

[ZhixuNi]

Hi @RaenonX @yihuajack !

I've got a solution to make it work.
You need to manually use the Registry Editor to edit somethings:
I think this is due to some issues, the WakaTime msi installer failed to generate some keys.
According to MS official website:
https://docs.microsoft.com/en-us/visualstudio/vsto/registry-entries-for-vsto-add-ins?view=vs-2019

Following keys have to be created under:
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Word\Addins

The most important is the Manifest vale:
for me the value is:
file:///C:\Program Files (x86)\WakaTime\WordWakaTimeAddin\WordWakaTimeAddin.vsto|vstolocal

You have to find your own path to WordWakaTimeAddin.vsto file.

Edited:
Manifest for Excel:
file:///C:\Program Files (x86)\WakaTime\ExcelWakaTimeAddin\ExcelWakaTimeAddin.vsto|vstolocal

Manifest for PowerPoint:
file:///C:\Program Files (x86)\WakaTime\PowerPointWakaTimeAddin\PowerPointWakaTimeAddin.vsto|vstolocal

Then close regedit and start word you may asked to trust WakaTime and install the plugin.
Then you might get one more key in regedit and two times WakaTime COM addin in Word:

Anyway, I disabled one of it and it works now:

If the value:
file:///C:\Program Files (x86)\WakaTime\WordWakaTimeAddin\WordWakaTimeAddin.vsto|vstolocal not working, try:
file:///C:\Program Files (x86)\WakaTime\WordWakaTimeAddin\WordWakaTimeAddin.vsto which without |vstolocal

Hope this solution works for you as well!

[yihuajack]

@ZhixuNi Thanks for your solution! It works for me. Nevertheless, it seems that things are different for Excel and PowerPoint. Is there any way to solve this issue for Excel and PowerPoint?

[ZhixuNi]

@yihuajack
Hi!
Good to know that it works for you as well!
I added similar keys for Excel and PowerPoint and they work fine for me:

Manifest for Excel:
file:///C:\Program Files (x86)\WakaTime\ExcelWakaTimeAddin\ExcelWakaTimeAddin.vsto|vstolocal

Manifest for PowerPoint:
file:///C:\Program Files (x86)\WakaTime\PowerPointWakaTimeAddin\PowerPointWakaTimeAddin.vsto|vstolocal

Actually you do not need to add keys under AddinsData, since it will be created automatically when you start Excel/PowerPoint/Word. It only count how many times this plugin got launched.

[RaenonX]

@ZhixuNi Works like a charm, thanks!

[kmedri]

Hi, I have tried all of this and still cannot seem to get a connection working. It does not appear in my plugin status page. The same is happening for Excel. I have logging in Word however not sure what I should be looking for.
I get no errors and I can see the WakaTime option in the menu bar. The API key is added into the options ok.

[MicheleRabesco]

Hi, I tried all of the above but when I enter my API key I get this pop-up:

I noticed that when I try to enter my own API key I can't write the last 5 digits:

Is there a place where I can set my API key other than there?
Thanks

[yihuajack]

@MicheleRabesco This is because you indeed entered an invalid API key. The API key are all hex numbers

[kmedri]

@MicheleRabesco If you remove the waka_ from the beginning of the key it should work.

[MicheleRabesco]

@MicheleRabesco If you remove the waka_ from the beginning of the key it should work.

Okay, this worked for me, I didn't know that. Thanks a lot!