Forum Discussion

urpalani's avatar
urpalani
Helper II
9 years ago

analyze in excel

Hi,   When i download the data in Excel - Analyze in excel ,I am asked for credentials but after that it popups "The Following Error Occured:(The Operation Completed Successfully) , When i click ok...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I had this issue today and first I tried to download all versions of SQL_AS_OLEDB.msi that I could possibly find but nothing worked, so then I did the EXACT OPPOSITE of what you just wrote: I replaced MSOLAP with MSOLAP.7 and saved the file. And then it worked!

Mike_Carlo's avatar
Mike_Carlo
Most Valuable Professional
8 years ago

I was also having this issue. When I opened the file it was already formatted with Provider=MSOLAP,   I was able to replicate what Anonymous did in the file by adding .7, so now it reads Provider=MSOLAP.7 After this change I am able to load the odc file and use analyze in excel... IlanH what version of excel were you using?

 

I am using Excel 2016 MSO 16.0.8730.2046 64-bit

and just this morning installed the lastest version of OLEDB

x64_1033_3291099_SQL_AS_OLEDB

 

tarostok  Is there any reason why this would be causing an issue?  Why would my newer 2016 version of excel require the MSOLAP.7?  It is difficult to work with the analyze in excel function if I have to change every odc file I download from the service.