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.
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
@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-Let-s-upvote-this-feature-Temp/td-p/1105319
Hope this helps. Happy solving.
@prpanw you can either ask them to close the file or make a copy of it
how to make a copy
