We keep having an Excel 97 error occurring.
When a user has finished updating an Excel file & they try to save the file an error comes up on their screen ?Document Not Saved?.
Some of the XLS files have VBA & Micros in them but some don?t.
Nearly all of the files that are having this problem are on a shared drive.
We think the problem is down to people clicking on ?Notify? when someone is editing the file. Then the person who clicked on Notify saves the file and then the original person who opened the file tries to save it and they get the error. We have not been able to find out whether this is the problem yet?
I want to know if this is the answer and if so how to stop the error or and we disable the Notify button when a second person accesses the file.
Or is there another reason for this error.