How do you automatically modify a shared Excel workbook with python?

Question

I have an Excel workbook that I've shared with multiple users. I'm hoping to be able to automatically update data in the workbook using python, after which the updated data is then accessible to the users with whom I've shared the workbook. However, this is proving to be very difficult from a technical standpoint.

The Excel workbook has been shared using the regular sharing functionality available in modern versions of Excel:

I've tried a few ways of automatically modifying the data in the shared document, including using pandas and openpyxl packages in python, as well as automatically modifying data in a CSV file that the Excel workbook then connects to. In every case, although the data seems to have been automatically modified on my (master) copy of the workbook without any issues, the changes don't appear for the other users until/unless I manually open the shared Excel workbook. I'm not able to automatically make and save the changes if I were to have this workbook always open on my computer.

Is there any way of achieving what I'm trying to do?