Workaround for updating Files in One drive if open on another PC

[Sintek]

Hi All

I have 2 files in a one drive folder...Main & Sub

One person is continuously working on Main on PC1.

On opening Sub by another person on PC2, Sub Opens Main takes info from Main and opens a listbox with that info...
When clicking on the row in listbox, info appears in textbox.
Textbox gets edited and processed...Code updates Main and Sub closes and saves both.
Problem now is Main if it was closed would be updated but because it was open...when it finally closes, another version of Main is created.

Is there any way of overcoming this...I tried setting Main as a shared file but somehow does not allow such a setting as the file contains Tables.

How can I get the main to be updated as my code runs from Sub???
Is there a way for real time updates??
I am in a predicament and do not know how to overcome this...
Is there a way of checking if the file is open in one drive on this other pc???