Good morning all,
I recently discovered this behavior in Excel.
http://support.microsoft.com/kb/826741
This has some ramifications for .BDS files (or anything else that looks at the
modified date of an .XLS Excel file - I haven't seen the behavior with .XLSX
files)
If you open a .XLS manually with Excel 2007+, then very quickly - close it and
then open the file with the DataStation, there is a good chance BWS will see
the "temporary" filetime, rightfully think that it is a new file and clear the
.BDS file.
This isn't a bug in the DataStation. It is working the way it should.
But, basically this means, to make sure this Excel behavior doesn't cause you
grief...
If you have an Excel file that you ran an automation against, it wrote to
D("Status") etc., and you stopped it, or need to do further processing. Do not
open that spreadsheet in Excel until you're done with the D("Status") data.
Regards,
Thom
--- To post a message to this list, send mail to: [email protected] You are
currently subscribed as: [email protected] Unsubscribe in the
customer center on our website:
http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx
