Excel File Cannot Be Saved Due to Error

[Nikolova84]

Hello, I have the following problem with Excel, and I would be grateful if you could suggest a solution or provide an explanation for what might be causing it. When we try to open an Excel file located on a server (meaning we work on it from more than one computer), the following message appears: 'Errors were detected while saving ...xlsm. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.' After this message appears, we cannot save the file or close the program normally. We tried saving it in a different format, in a different directory, on our personal laptops, but that only provided a temporary solution to the problem, which reoccurred afterwards. The same problem occurred with two other files also located on the server. The common factor between them is the similar macros being used.

I would appreciate any suggestions as to what might be causing these problems since these files are important to us, and this issue is causing significant difficulties that we are unable to overcome.

Thank you in advance for your time!"

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel File Cannot Be Saved Due to Error
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.