Analyze in excel system error

Jeremie,

I can reproduce your issue in the 1709 version of Office.


However, Analyze in Excel feature works if I update Office to 1710 version, please update your Office to 1710 version.

Regards,
Lydia

Jeremie,

Please try the workaround below.

1.  Download MSOLAP 7 from here: http://download.microsoft.com/download/4/8/2/482E5799-9B8E-4724-8A4C-F301BAE788EE/13.0.3523.4/1033/x64/SQL_AS_OLEDB.msi

2. Close all office applications

3. Go to: C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140 and rename the adal.dll to adal_orig.dll (if you have excel 64 bit use the version from Program Files)

4. Copy the adal.dll from here: C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\130 to: C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140  (if you have excel 64 bit use the version from Program Files)

5. Open the odc file and see if it works for you.

Regards,
Lydia

Jeremie,

The response of PG is as follows:

The root cause of this issue is the ADAL library (version 1.0.2044.414) shipped with MSOLAP 8. We are now pushing for updating the ADAL version in MSOLAP and Office. This could take a while.

Regards,
Lydia