ghost excel back up file

[vtisix]

Hi All,

I have an excel worksheet with huge calculations. The calculations are
linked to a separate data sheet, which is system generated. I've checked
all the macros to make sure nothing is saving a back up version of the
workbook, but it still does that (I inherited this workbook), also looked in
the Tools > Options > Save and unchecked both the AutoRecover boxes. The
problem comes in when the user download the main workbook and the new data
file, then the #REF errors are everywhere. If Ctrl + Atl + Shift + F9
function is performed, then the workbook recalculates correctly.

So, my questions are:

1. How do I disable the ghost auto backup function?
2. I believe the fact that the backup file isn't download w/ the main
workbook is causing the #REF errors.

Any thoughts?

Thanks,

VT

 

[Don Guillett]

Try checking the DISABLE auto recover instead of unchecking

 

[VT]

Thanks, I tried that too.

Try checking the DISABLE auto recover instead of unchecking