How to open an excel ready only when it was open by another person exclusively

[Kuha]

I am trying to open an Excel file read-only in Alteryx. When the file is opened by another person exclusively, getting an error "it's used by another person".

Is there any workaround to resolve this issue?

Kuha

[BRRLL99]

If the Excel file is already opened exclusively by another user, then you won't be able to open it in Alteryx. This is because Excel locks the file to prevent other users from modifying it while it is open exclusively.

To open the file in read-only mode, you can ask the other user to close the file or to close Excel if they are no longer using the file. Once the file is no longer exclusively opened by another user, you can then open it in Alteryx.

Alternatively, you can try making a copy of the Excel file and working with the copy instead. This will allow you to open the copy in read-only mode even if the original file is exclusively opened by another user. However, keep in mind that any changes you make to the copy will not be reflected in the original file.

[Kuha]

Thanks @BRRLL99 

[Nonsensely]

We have this problem when trying to pull daily production scores from worksheets they refuse to quit using, even though we have a database created for them to enter their data. We tried hidden macros to copy them to another worksheet for Alteryx use each time they Save, tried adding a "send to Alteryx" button, etc., yet the copies never seem to be updated. So, now I'm stuck having to go in each morning, open the worksheet, click the "send to Alteryx" button and then run the workflow. 

[BRRLL99]

please try creating YXBD format files for database. Whenever you run the YXDB workflow, it will automatically update the file.