Unable to read Excel Input when the file is being opened in Excel

[ivan_wiryadi]

Hi, 

So I just recently updated my Alteryx Designer from 2021.2 to 2022.1 and noticed that now I'm unable to input data from Excel files that are currently open in Excel. Never had this problem with the previous version.

Error: Input Data: The process cannot access the file because it is being used by another process. (32)

Is there any way to configure Designer so that it could read Excel files that are currently open? 

Thanks

[Qiu · Accepted solution]

@ivan_wiryadi 
There is a report about this issue. and failed to see any response from alteryx yet though.

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Data-input-from-open-file/idi-p/921332

[ivan_wiryadi]

Thanks! So.. there's nothing that we can do except using previous version / wait for an update?

[Qiu]

I am afraid that is the case for now.