I’m getting an intermittent Excel 2007 “changes could not be saved” error under Win 7 that did not occur under Vista.

I’m working in a macro-enabled file that I use every day. It has about 15 tabs. Sometimes when I save the file, I get the following message requiring me to follow the sequence shown here:

1. “Your changes could not be saved to ‘filenam.xlsm’ because of a sharing violation. Try saving to a different file.” Only one Excel file is open and I respond with okay which is my only choice.

2. Then I get the message “The file your are trying to open, ‘65E6A400’, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?” I respond with no.

3. Then I get the message “Your changes could not be saved to ‘filename.xlsm’, but were saved to a temporary document named ‘65E6A400’. Close the existing document, then open the temporary document and save it under a new name” I respond with okay which is my only choice.

4. Then I close the file and close Excel

5. Then I re-open filename.xlsm (the original file) and it sometimes appears to have all of the recent changes but sometimes it doesn’t. Sometimes the original file does not have all of the changes and I have to delete the original file and open the file ‘65E6A400’ and re-save it with the original filename.

I’ve been using this file for several years and I never had a problem under Vista (Excel 2007) or XP (Excel 2003). Can you please help me resolve this problem?

Thanks,

Don Krafft