[Python] Can you override the "This file is in use" message from excel when interacting with...

I am attempting to connect python to excel, using VSCode, a pySide6 GUI and xlwings and win32com. Whilst I can manage to update an excel document when it is closed, I cannot seem to be able to do live updates with excel being open. The aim is to have an excel co-pilot style design, but every time I try and locate the file through my code with the excel file already open, I get the "this file is in use" error.

Is there any way to override this microsoft locking system, so that I can have both the copilot and excel document updating each other at the same time?

Continue reading...