Yes, it has to be done on a Sheet by Sheet basis Justin, and it will disable the auto saving, but to be honest, it still never works correctly and 80% of the time it wont save what you need.
You are always best to routinely press CTRL+S to do a real save.
This can be caused by data errors on the computer, or the files became corrupted. Especially if its from Excel 2004.
I would advise you do the following to make sure the computer is ok.
Download CC Cleaner (free) from hereCC Cleaner
(Click Download Latest Version on the top right)
Run it and let it scan and repair your registry.
Once done, restart the computer
Click Start, All Programs, Accessories, right click on Command Prompt and select Run As Administrator.
A black window will open.
Type in it
press enter and when it has completed, type in
It will give a message "the type of the file system is NTFS cannot lock current drive.
chkdsk cannot run because the volume is in use by another process. Would you like to schedule this volume to be checked the next time the system restarts y/n" Say Y, press enter and restart the computer.
This will remove any issues on the computer in regards XXXXX XXXXX so if you still have the issue, you know it is the files that are the problem, and your best to copy and paste these into new files.
If you have continued problems, or would like any additional information or assistance, please do not hesitate to let me know.
And if you can take a second to rate my service, that would be greatly appreciated.