"Invalid Worksheet. Worksheet is empty" for full worksheet

[VollCorner_Biomarkt]

What is your goal?

My automation that’s been in use for months won’t run because module 1 List Worksheet Rows (Microsoft 365 Excel) generates this error message: “Invalid Worksheet. Worksheet is empty” The worksheet has 71 filled rows.

What is the problem & what have you tried?

I have tried updating the connection, reconnecting the file and worksheet and adding a dummy row into the worksheet.

Background: The run scheduled yesterday didn’t run due to the same error message. But the data was missing from the worksheet afterwards. I figured Excel had just crashed. So I restored the excel file’s version from yesterday and wanted to run it again today. But same error message. Yesterday I had also changed the limit in that first excel module from 100 to 200 (just in case this is relevant).

Error messages or input/output bundles

Invalid Worksheet. Worksheet is empty

Screenshots (scenario flow, module settings, errors)

[VollCorner_Biomarkt]

Update: I’ve copied the data into a whole new worksheet and connected the module to this. It worked at first, but one column brought about a problem that also didn’t exist before: It was the start_on-date for Asana in the correct format MM/DD/YYYY. I’ve deleted all the mapping in all Asana modules for the start_on-date and now it’s working.