how to open excel fiel as ready only

[prpanw]

Can someone help me to how to oepn excel fiel as ready only because I am trying to open file with dynamic tool but if someone is already opened then it is throwing error.

[Deano478]

@prpanw you can either ask them to close the file or make a copy of it

[prpanw]

how to make a copy

[Deano478]

You can just right click on the file name in your file location and copy it to a new location or in the same location and just rename it so you know it's not the original file 

[TUSHAR050392]

@prpanw You can check out the macro in this thread to read already open excel files - https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Data-Input-while-File-is-open-...

Hope this helps. Happy solving.