Bex and Excel 2007

Hello,

I have recently upgraded to Office 2007 (from office 2003). I have BW 3.5, and SAPGui 6.40. I can open my BW Queries and Workbooks as expected. However, if I go to OLAP Function for Active Cell, then Properties, I encountered a u201CRun-time error u201813u2019: Type mismatchu201D.

I have tried Note 1052761 - Pre-requisite for using 3.5 BEx Analyzer in MS Excel 2007 but to no luck.

Sap Note 1045244 3.5 BEx Analyzer raises Runtime error 13 suggest to download sapbex.xla but I canu2019t find it in the internet.

I also tried running the Installation Check but there are no red flags.

I probably have missed something in here, any help is highly appreciated.

Thanks in advance!