Error while opening Analysis for Office file

[Former Member]

Hi all!

I am facing an issue while opening an AO file:

An exception occurred. Send the attached log file to your administrator. SAP BI Add-in will be closed. If you want to save the data in the document, you must save a copy of the document because the data needed for the addin functions cannot be saved correctly. (ID-102001)

It only happens on Microsoft Office with 64 bits, in 32 bits, it does not happen.

I unistalled and installed Microsoft Office and AO addin but the issue persist.

The only way to open it without issue is, open a new blank workbook, login into AO, then open my AO file, by doing this, the file is opened correctly

I searched this issue everywhere but I could not find a solution for this.

Can you give me a hand on this, please?

Thanks & Regards,

[VijayetaSharma]

We uninstalled office with MS provided cleanup tool. To remove all traces of previous installations and install a fresh version larter. Seems like cleanup tool did the trick

[ajay_balaji_j]

This is an old issue. Is there a proper solution for the above error?

[pascaltopolewski]

Hello Christian,

which Analysis for Office Version are you using?

Best regards

Pascal

[Former Member]

Hello all,

Do you have any solution for this problem?

I am facing with it.

BR,

Tin Tran.

[Former Member]

Hello Tin,

I could not fix this issue yet.

Regards

[former_member627544]

Hello Christian,

Did you fix this issue? I am also getting same error.

[Former Member]

Hello Pankaj,

Sorry for the delay, I could not fix this issue yet.

Regards.

[kkbonam]

Hi

Did you cheeked the connection in the workbook ? try with Replace System, select another connection and see if it works.

Regards,

Kiran

[Former Member]

Hi Kiran, thanks for your answer!

I replaced the system but the issue persist. It only works if I login into the system in an empty workbook and then, open the workbook with the structure. But the same file works in 32 bits if you directly open the AO file.

Thanks & Regards,