For now I reverted back. I currently have Excel 2.9.3 and System Activities 20.10.4
Please advise what version are good to be able to use Generate Datatable and Use Excel Process Scope without errors.
Yeah you might have to replace some activities, because you’re coming from such an old version. That’s exactly what you should do. Upgrade all dependencies then fix whatever breaks. What version of Studio are you on?
I am using whatever default
Default what? Packages? That’s based on your version of Studio. If you’re on such an old version of Studio that it’s using System 2020.10.4 then you are looong overdue for an upgrade, and that’s probably why the new version of the Excel package doesn’t work. Package versions are dependent on Studio version. It tells you right in the package description (in Manage Packages) what version of Studio it requires.
That’s why you can’t upgrade the Excel package. Pay attention to the package description in Manage Packages. It’ll tell you the version of Studio required for the package.