Forum Discussion
Excel.CurrentWorkbook() crashes
Hi All, Something really weird happened to me, and by extention, my colleagues. I set up recently (like a month ago) a new but very simple query that basicaly takes 2 existing tables, reshapes b...
Thank you, it's very informative. I've actually tried to do it this way, and get data from the document itself by doing Get Data-from Excel. Unfortunately for me, it appears using Office 365 makes this impossible as when I tried to load the Data I have the error message that this document is already in use. I am yet to find a way to bypass this
Hi Bertuccio ,
For heavily-used Excel files, I would recommend looking into using Power Automate Flows to detect when the modified date of the file changes on SharePoint, then copy it to your own 'safe' location elsewhere on SharePoint.
This should ensure you always have the most recently-edited version of the file in a no-lock environment.
Pete