I have a macro that runs every minute on an open spreadsheet and saves the file at the end of that process. The problem that I am having is that once in awhile when the file trys to save, it is saying that the file is being used by another user, this doesnt happen on every save, i'm not sure if it's a problem with excel or our shared drive. suggestions? This program may run fine for 4 days or longer, other times it throws the errors more frequently.