problem about power-pivot-Collection of common programming errors

2 years ago
admin
2 minutes

  • msdn
    sql-server-forums power-pivot
    I recently encountered a strange, yet repeatable, bug that popped up during a training session I was doing with 5 users. We were all using Excel 2013 / PowerPivot to extract data from SSAS MDM 2012. We all got the following error when attempting to refreshthe Pivot Table from the Excel side: Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.Exception from HRESULT: 0x800AC472.See here for the

  • msdn
    sql-server-forums power-pivot
    Hi All,I’m getting the following error in a SQLDUMPER.exe CMD box when trying to use a slicer in powerpivots,Unable to open file \\?\c:\program files\microsoft analysis services\as oleddb\10\flightrecordercurrent.trc, error 2I’ve googled and found others that have had the same problem, some which were fixed by reinstalled powerpivots, unfortunately that fix didn’t work for me, any ideas?Thanks,Mark

  • msdn
    sql-server-forums power-pivot
    I am using powerpivot v2 with excel 2010.When I go to my excel file’s powerpivot and I try to insert a formula in any column, I constantly get the following message: “unhandled exception has occurred in a component in your application. If you click continue, the application will ignore this error and attempt to continue”.************** Exception Text **************System.InvalidCastException: Return argument has an invalid type.   at System.Runtime.Remoting.Proxies.RealP

  • msdn
    sql-server-forums power-pivot
    I’ve just upgraded to PowerPivot ‘v2’ (11.0.2100.60) and now a powerpivot table created in ‘v1’ throws an Unhandled Exception.A rollover of the powerpivot tab reports that ‘one or more formulas have errors’ but the table itself doesn’t display when clicked, I instead receive an Unhandled Exception error: “Index was out of range. Must be non-negative and less than thesize odf the collection. Parameter name: index”Can anyone shed any light on what I might need to do to resolve

Originally posted 2013-11-27 11:58:44.