sounds like a simple problem, but I try to solve it since 3 days.
We did a dependency update (23.10 to 24.10 enterprise) and changed lots of “read workbook” activies to Excel application Scope and since then one particular process starts to make problems when reading an Excel file.
Excel file is not too large, has no formulas etc. just plain data.
The general process itself is quite old so I`m not sure if maybe some old dependencies make problems here.
In general, I want to read several Excel files.
It always crashes with “Could not read Range A1” when I run the process n2n.
I built a little testsequence and voila its working like charme.
Already rebuilt one logic entirely but this one fails as well when running n2n.
Also I force click into the open excel application to activate it. That actually helps in every 10. run in the retry but is far from a stable solution.
I`m a bit out of ideas.
If anyone experiences something similar would love to hear your ideas
Use excel process scope around and use settings from there for process mode to be automation..force kill or existing process disable macros if not needed
Pls update all Excel activities to latest version Avoid mixing modern and legacy dependencies add a small delay ,Use excel scope before read range ensure Excel is launched and responsive check debug logs for UI timing issues
