Our department head has a shared workbook that many people have open throughout the day. He is the owner, so we can't really modify anything outside of the cells or make any macros, and he won't modify any of the settings himself.

I'm not sure if what I'm looking for is even possible. I'd like to make a script, probably using Powershell, that'll either update or save an already open workbook. I do have a script that'll determine the PID, kill it, and re-load the file, but that is less than ideal for several reasons.

In any case, I can't find any help searching the internet, maybe someone has run into this before?

Excel version 2404

Thanks,