Question Re: Error while opening Analysis for Office file in Technology Q&A

Error while opening Analysis for Office file

Former Member — Mon, 02 Mar 2020 19:59:40 GMT

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,

Re: Error while opening Analysis for Office file

kkbonam — Tue, 03 Mar 2020 16:11:48 GMT

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

Regards,

Kiran

Re: Error while opening Analysis for Office file

Former Member — Tue, 03 Mar 2020 18:53:55 GMT

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,

Re: Error while opening Analysis for Office file

former_member627544 — Tue, 16 Jun 2020 09:11:40 GMT

Hello Christian,

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

Re: Error while opening Analysis for Office file

Former Member — Mon, 10 Aug 2020 10:28:20 GMT

Hello all,

Do you have any solution for this problem?

I am facing with it.

BR,

Tin Tran.

Re: Error while opening Analysis for Office file

Former Member — Tue, 11 Aug 2020 20:28:13 GMT

Hello Pankaj,

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

Regards.

Re: Error while opening Analysis for Office file

Former Member — Tue, 11 Aug 2020 20:28:25 GMT

Hello Tin,

I could not fix this issue yet.

Regards

Re: Error while opening Analysis for Office file

pascaltopolewski — Wed, 07 Oct 2020 12:25:59 GMT

Hello Christian,

which Analysis for Office Version are you using?

Best regards

Pascal

Re: Error while opening Analysis for Office file

VijayetaSharma — Wed, 04 Nov 2020 21:44:01 GMT

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

Re: Error while opening Analysis for Office file

ajay_balaji_j — Thu, 22 Jun 2023 00:04:03 GMT

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