We have a shared workbook that is modified and viewed by several people throghout the day. Most users are in read only, but 2-4 might be in write mode at one time. The issue we have is that when someone saves the file, the save process is not completing and the original file is deleted, but the temp file is not renamed.
Excel creates the temp file when the shared workbook is opened up, when the user saves the shared file the original file is deleted and then the temp file is renamed to match the original name. The temp file on the server is occasinoally not being renamed and I have to manually rename the temp file to get the file back. This might happen once a week, month... Yesterday it happened 3 times. This happens occasionally on all of our shared files.
Is there a way to prevent this from happening?
Excel creates the temp file when the shared workbook is opened up, when the user saves the shared file the original file is deleted and then the temp file is renamed to match the original name. The temp file on the server is occasinoally not being renamed and I have to manually rename the temp file to get the file back. This might happen once a week, month... Yesterday it happened 3 times. This happens occasionally on all of our shared files.
Is there a way to prevent this from happening?