VB err msg

[DL]

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?

 

[Joel]

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]

No thats not it, 'corrupt' was probably the wrong word to use, all the cells
that contain macros/references display '#NAME'
Close the workbook, without saving, reopen, and if no 'File Exists' err msg
the workbook is intact and all cells correctly displayed.

 

[Joel]

Did you try the tool? Is your excel installed local or are you using a
version of excel on a server. where is excel installed? (what type of drive,
local or network) Are any of your formulas referening another file?

I thinking a library reference is found or another workbook is being found
when the workbook is opened.

 

[DL]

Installed locally, no network or server involved
Both Excel & the workbooks exist on the same drive
The vba macros draw info / are linked to a third application, on the same
drive
Since there is no actual file corruption I havent used the tool.