Obtain the workbook

[Wtower]

According to the documentation

https://docs.xlwings.org/en/stable/api.html#xlwings.main.Books.open
https://stackoverflow.com/questions/49883687/xlwings-book-hangs-if-file-is-already-open/49905875#49905875

xw.books.open() should return a specified xlsx file and open it if not yet open.

This does not work well for workbooks that are shared in OneDrive or live in shared folders of OneDrive. Any attempt to open, or even access the fullname property of that book throws the following error.

xlwings.XlwingsError: Couldn't find your local OneDrive file, see: xlwings.org/error

This is a false error description after many hours of investigation.

A workaround would be to check the name property for an open worksheet of the same name, ignoring the path.

This is very dangerous if another workbook of the same file is open (both cannot be open as xl forbids it).