locked
Powerpivot+getting EXCEPTION problems from HRESULT 0x800a03ec AND ALSO from HRESULT: 0x800A01A8 RRS feed

  • Question

  • Hi,

    I have a new PC and just installed office 2010, powerpivot v2, Net framework 4, Visual studio 2010 for office runtime (all properly installed)

    I use powerpivot to extract data from an SQL. As I started dragging fields in the powerpivot field list and then started getting the following messages:

    EXCEPTION from HRESULT 0x800a03ec..... AND ALSO..... from HRESULT: 0x800A01A8

    Additionally, the fields that I dragged into the powerpivot field list areas, they get stuck there, although they no longer work.

    I will appreciate if anybody know how to resolve this. Please provide step by step instructions because I am no expert.

    Thanks.

    Thursday, September 6, 2012 10:43 PM

Answers

All replies

  • Dear AlexRK,

    After all those Installations, Have you restarted your System. Please tell the Sequence of Actions you Do so from the time you Open Excel So that I can check where exactly might be the problem.

    Regards,

    ManjunathRV

    Saturday, September 8, 2012 12:50 PM
  • Hi ALEXRK,

    If we install the 32-bit version of Excel, we must use the 32-bit version of PowerPivot. If we install the 64-bit version of Excel, we must use the 64-bit version of PowerPivot.

    In your case,, I suggest you can try to reinstall SQL Server PowerPivot for Excel. For more information, please see:
    SQL Server 2012 PowerPivot for Microsoft® Excel® 2010: http://www.microsoft.com/en-us/download/details.aspx?id=29074

    Regards,
    Bin Long


    Bin Long

    TechNet Community Support

    Monday, September 10, 2012 6:24 AM
  • Hi Bin Long,

    Of course I installed the 64-bit for my 64-bit system.

    After reinstalling office, visual studio and Net frame....the problem continued.

    So, I started from scratch by reinstalling a virgin IMAGE of my PC as well as reinstalling all the above mentioned. Then the problem disappeared.

    However, Powerpivot has a glitch, as far as adding values in the "values" area of the pivottable field list. SEE ALL INFO HERE:

    http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/28d6adcb-afe5-484e-9274-baeff006e6f7

    Monday, September 10, 2012 4:16 PM
  • Hello,

    Thanks for your response.

    Please ensure that you are using Office 64bit and PowerPivot 64bit versions.

    It seems you still struggle with this issue. For this issue, I would suggest opening a case with Microsoft Customer Support Services (CSS) (http://support.microsoft.com), so that a dedicated Support Professional can assist you in a more efficient manner.

    Thanks for your understanding.

    Regards,
    Bin Long


    Bin Long

    TechNet Community Support


    Tuesday, September 11, 2012 3:14 AM
  • Hi ALEXRK,

    Your issue has been solved in the following thread:
    Powerpivot pivottable - I can't add or drag a "value field" from the pivottable field list into the "values" section.: http://social.technet.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/1e8e6f09-8c28-4768-bdd5-0f27ac90f98e/

    Regards,


    Bin Long

    TechNet Community Support

    Monday, September 24, 2012 3:13 AM