I want to update two tables in the same excel workbook but different worksheets. However, when after I update"Table 1: Current month" in worksheet 1 , I am unable to update "Table 2: in worksheet 2 (Both the worksheets are located in 1 excel workbook ). I get the following error on running “export excel” for same workbook :
Error: The process cannot access the file:
"C:/Workbook path’ because it is being used by another process.
Source: Action “Export into Excel file” in table “Termination Details (Weekly) - IDP - Last Month” in project “C:\workbookpath”
Can someone please help?
. I got it working…