Excel 2007 File Saving

[Guest]

Whenever I am working on Excel 2007 file, out of nowhere msg pops-up: An
Unexpected error has occurred. Autorecover for this session has stopped.
The diologebox has only choice of: Ok.
Pressing that lets me work normally.
However when I try to save my file by Save As .xlsx file I get messsage like
this: error occure in saving this document. Your work may be lost. Excel
may be able to save the work with loss of information. (The message of this
nature).
Dialogue box choices are continue, cancle or (X) Close.
When I choose continue it forgets my Save as file name and goes back to
default name e.g. Book1. I can change the name and save. But before saving
I get one of the two messages: Damages to your file were so extensive that
Excel could not repair. OR Excel has saved your document after repairing.
There may be loss of data or fidelity. When I reopen saved document many
times tremendous loss of formatting etc. or occassionaly minor loss -but some
loss always. PS This workbooks are not too large -up to a few hundred KB

 

[Bill Manville]

Oh dear.
It sounds like there is something about these workbooks that Excel 2007
doesn't like.
It might take some experimenting to isolate the problem.

Things I would try, to get more information about the problem would be:
- try saving in Excel 97-2003 format - does that succeed where 2007
save fails?
- see if it is a problem with newly created workbooks
- save a blank workbook and re-open it
- add some data and formatting (similar to what you use in the
failing workbooks but not by copy/paste) and save the workbook
- if you don't get the problem with a new workbook but do get it with
an old one, what is the history of the workbooks that give the trouble?
- starting with a workbook that opens OK but fails on Save, try opening
it and deleting features (e.g. worksheets, charts, etc) from it and
doing SaveAs until you track down a feature that seems to be related to
the problem.
- try opening Excel with the shift key held down (which inhibits the
loading of add-ins). Does this change the behaviour at all?

Let us know what you discover and maybe we can help get to the cause.

Bill Manville
MVP - Microsoft Excel, Oxford, England