I have Excel 2013 64bit running a macro that goes through a series of files in my local drive, opens them, refreshes the power queries inside, save and close; this process runs daily, and has worked well since the beginning.
Yesterday one of the files could not be saved, with the message "your changes could not be saved because of a sharing violation", then Excel tries to force me to save with another name. I also cannot delete or cut the file, saying the file is "opened in system".
Since yesterday, this behavior has spread to two more files, rendering them useless. I cannot find a rational explanation nor a solution for this, and this process is critical for my company. Does anyone have any idea of how can I solve this issue?
Yesterday one of the files could not be saved, with the message "your changes could not be saved because of a sharing violation", then Excel tries to force me to save with another name. I also cannot delete or cut the file, saying the file is "opened in system".
Since yesterday, this behavior has spread to two more files, rendering them useless. I cannot find a rational explanation nor a solution for this, and this process is critical for my company. Does anyone have any idea of how can I solve this issue?