I get this error whenever I run my task in StudioX. I am trying to follow the instructions in the course of creating Build your first Automation. Everything runs fine until it tries to create a pivot table. I downloaded the solution and tried to run it to try to figure out what was going wrong and I got the same issue. This is very frustrating when you are trying to learn. Is there anything I can do to get past this issue? Please help
I am running the current community version and I am using excel 2010
Something went wrong with Excel .
Activity Create Pivot Table ( Create Pivot Table X ) failed:
Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)) Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))
You can find the activity following this path:
Main > Use Excel File > Create Pivot Table.
Excel file path: Report.xlsx