Twice in the past week a colleague has encountered an issue with Excel 2010 where the application suddenly ceases to perform its Save and Save As functions on all open workbooks, with no error messages or warnings returned when pressing the associated buttons.
- The user can press 'Save' as many times as he wants, but the operation does not perform.
- When going to File > Save As, no menu appears and you land back on the Home tab.
- Our office also has an Excel add-in for 'Open Text Explorer' or 'Livelink' which is an intranet file management system, and though its Save dialogue actually allows you to navigate and give a file name, it also fails but does return an error (but we didn't log the actual message it gave).
- The only other noteworthy Excel add-in we use is 'PI Datalink' which allows us to retrieve live production figures from several company servers. This has been in-use regularly for many years, is using a recent version and has never been observed to cause any sort of application issues like this.
So whether using native Save functionality or Livelink, Excel is just plain unable to save. Save functionality is recovered once the application has been closed and re-initialised, and the documents can then be opened and saved as normal. The immediate issue can be worked around by using Send As Attachment to recover the unsaveable files before reinitialising the application.
I can't find any related threads. Has anybody encountered anything like this issue before, or have any idea on root causes?