There is an excel sheet which is like a template. so in the automation its needed to update data on the sheet at intervals. for eg. download data and write the downloaded data on main sheet. Its working completely fine but after uncertain time when I try to read data from this sheet “Main”… It throws Read Range : Couldnt read range error .please find the error screenshot below. So when I delete this sheet and create exact sheet name again it doesn’t give me error. P.S I cant use external activities here so please help. when I use workbook activity to read it gives “Not a legal OleAut date” error.
p.s. i am using same sheet name and also excel file exists