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?

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?

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" wrote in message
...
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?

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" wrote:

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" wrote in message
...
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?

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.

"Joel" wrote in message
...
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" wrote:

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" wrote in message
...
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?