File error: data may have been lost.

Does this happen on all Computer?
Does this happen in all workbook with these functions?

- Computers - It has occurred on at least 2 computers in the work-group that are running office 2007
- Workbooks - only workbooks that have been opened, edited and saved from 2007
- Service Packs - all service packs and fixes for OS and product have been applied
- 03 Native file - these are Excel 2003 created files (.xls) that are being opened and worked on within Excel 2007
- Compatibility Mode - yes - When Excel opens a .xls file it automatically runs in compatibility mode

Try:

Uninstall Office
Reboot
Re-install office, making sure to select a "Full" install.

JeffCoachman

- Put a new hardrive in, reformatted, re-installed all programs, did a "Full" install - result was "File Error:..."

*Ouch*

Scan for viruses?

Not sure buddy,
Time to put a call into Microsoft, perhaps?

:-)

JeffCoachman

Yup - virus software is up to date

I have already called Microsoft, paid the $300 and received a mis-diagnosis.  When I informed the support engineer that the problem has re-occured and to re-open the case, they did not reply to my emails.  

While I hate to speculate - it appears as though Excel 2007 is NOT COMPATIBLE with 97-03 file types with the extension of .xls if they have any VBA code associated.  

At this point I am working off the computer I have 2003 loaded onto (and I should add: I am not having any problems with 03 on it).  I am leaving 2007 on the other computer, but am not planning to do anything serious with it.  I have recommended that the users that use the affected workbook only do so with Excel 2003 - ie don't upgrade.  While I am loathe to put the brakes on an upgrade, the silent corruption of 03 files by 07 software leaves me no choice.  

Thanks for your effort -

Chad

Chad,

One more thing...

If you open the code in Excel 2007, can you compile it?
(Debug-Compile)

Jeff - hi,

It does compile - however....

1. I compiled it, saved it, closed it, re-opened it - all successful
       a. on the surface this look successful and is how Microsoft support generated a mis-diagnosis
2.  then I closed it, re-opened it, deleted a trivial worksheet, and saved it
       a. problem starts again
       b. it notifies me that the crypto API is being accessed (the project is digitally signed)
       c. it tells me that excel has encountered an error and has to shut down
3.  When it re-opens, a 'repaired file' is presented with the following observations:
      a. the digital signature has been dumped (although no code was modified by me in the above process)
      b. instead of corrupted cells, the cells now have no formula in them whatsoever

Conclusion - I just can't use 2007.  I can do this in Excel 2003 without any problems...

Any other ideas?

I dumped the digital signature and ran a couple of test - so far - success.  Based on a previous mis-diagnosis, I am reluctant to say the issue is fixed, however, this is a new success.  So thank you.

I have the same problem -was the "Accepted Solution" tag above was a slip of the mouse, btw?.  Can it be solved by avoiding the "toolkit" functions, perhaps.  Has there been any development since the last post above?

RingProp,

I don't know if you can say "Solved".

My thought is that if you strip away anything "Extra" and it works, then that's what you may have to do.
;-)
JeffCoachman