Error received when opening an Excel document in Transaction 10.x:
"An error has occurred while generating preview. Corrupt OpenXML document"
No error is received when opening the same script in Studio 11.x.
Excel file is password protected.
Remove all protections on your Excel file, checking also if any hidden sheets might be protected.
Change extension to .xls(Excel 97 -2003) instead of .xlsx
Go to Review Tab in Excel and click on Share workbook.
Check the "Allow Changes by more than one user at the same time " checkbox.
Uncheck the "Allow Changes by more than one user at the same time " checkbox and close Excel.
Now open Transaction and mention the changed data file and run the scenario.