I am currently working on the UiPath Training Build your first Automation.
I have Excel 2010. Everything was working fine until I tried to create the pivot table.
Whenever the create pivot table activity is run, I get the following error.
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))