Sharing violation issue

[mskli]

Hello:

I recently got someone to write a python program that creates an application. Part of the application is to open an Excel with a particular spreadsheet. This all works fine - however when I go to make manual changes to the spreadsheet and save it I get a "your changes could not be saved to TestMD.xlsx because of a sharing violation. Try saving a different file" what does this mean? (If I close the application that brought up Excel then I can save it)

 

[6StringJazzer]

This is a notification from Windows, which is passed back to your application, that you are trying to use one process to write a file that is locked by another process. How does your Python code open Excel? I am not a Python programmer but I have written in several languages professionally so I can probably suss it out.

One possibility, but I have never done what you are doing, is that the Python runtime locks the Excel file, and so Excel itself cannot save the file. But I can't be sure without at least seeing your code, and possibly trying to run it. What Python environment are you using?