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

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

Input

Accepted answers

Qiu

@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

All comments

Qiu

@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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703