You may be able to use the microsoft recovery tool when the book is open and
corrupted.

Start - Programs - Microsoft Office - Microsoft Office Tools - Microsoft
Office Application Recovery. This worked for somebody else last week.
Select Excel application and follow instructions.


"DL" wrote:

If the wrong group I apologise in advance.
This has occured both in Excel 2003 & 2007, on winxp, office & win updated
I use an add-in, with which I create a new workbook containing various
formulaes etc , I open the excel file do some work, save & close, open
another and sometimes receive an err msg titled 'VB' with text 'File
Exists', OK the msg and the work book opens but all entries are corrupt (The
calculations) close & dont save the workbook, wait 30 sec's reopen & its
fine.
I can work on many excel workbooks created with the add-in for several hours
without any problem, but all of a sudden it occurs.
According to the developer he cannot reproduce the problem & states no other
user (there are many) has reported it.(the add-in uses .xla files)
Could anyone shed any light?