I am preparing a datatable by manipulating different datatables and then dumping that final data into an old excel. I am using Write Range Activity (Workbook) for data dump. But it is giving this error: “Write Range: Syntax error”. I tried using Write Range Activity (Excel) but it gives this error: “Write Range: Could not write the data table DataTable starting with cell A17000:M17432.”
When i am using write range activity for fresh excel then it’s working fine.
I checked for hyperlinks but there are no hyperlinks in the old excel. What can be the possible reasons for this issue.
Any help or hint would be highly appreciated.