We have now in total 3 users who are facing exact same issue that when they try open analysis for office report, multiple excel version opens up. Also the analysis and analysis design tab is also missing from the top bar. When we try to add the analysis tab by browsing to Options-->Coms Add in--> and Check the Analysis tab and click ok.
Still the Analysis icon is missing from the top bar of the excel. And when we again go and check the above path of Coms -add in, the analysis is in checked state. PFA.
Since Analysis tab is missing we cannot enable support mode as well to generate the log files. The basic trace file generated had below error.
2021-07-21 16:00:10,450|ERROR|addins.launcher|Com.Sap.Cof.Launcher.OfficeGetterHelper.GetISapCofComObject|1|Cannot get ISapCofComObject; did you call 'regasm /tlb CofInterfaces.dll' ?# 2021-07-21 16:00:10,450|ERROR|addins.launcher|Com.Sap.Cof.Launcher.OfficeGetterHelper.LaunchWithFile|1|Connect to addin failed; launch file cannot be evaluated.# 2021-07-21 16:00:10,451|ERROR|addins.launcher|Com.Sap.Cof.Launcher.Launcher.Main|1|System.Exception: Failed to launch file.
Also all the 3 users is having same issue the AFO version is different.
2 users have AFO 2.8 SP 03 and one user has AFO version 2.6 SP 03.
MS Office - 365 Pro Plus 16 /Skype 2016 version
Any leads on how to solve this issue. Thanks.