It is not possible to make changes to the Excel file while it is open. openpyxl. Python. What can be done?

Question

Python

It is not possible to make changes to the Excel file while it is open. I am using openpyxl. While the file is closed, all data is written, if opened, a PermissionError is thrown

Answer 1

Wait until it closes. Excel does not allow two processes to open a file.

Answer 2

Close. Your cap.

Answer 3

overwrite this Excel file
That is, delete the old one and write a new one with the same name

Answer 4

before opening, add a macro to the document (or write it to new templates) that will receive commands from your external program using some protocol and edit the document.
the lion's share of coding here is exactly the means of communication IPC
ps can push all the logic completely into the scripts of the document? and not write it in python (although VBS is still a language)