Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Correcting a "File error: data may have been lost" in Excel 2007
32 views
Skip to first unread message
Cory@discussions.microsoft.com MMC Cory
May 8, 2009, 12:26:06 PM5/8/09
to
When I opened a large excel 2007 file I received the following error message:
"File error: data may have been lost". Many of the cells had the inputed data
replaced with an error message #VALUE! and it appears that the data is lost.
I need to know if the data is lost, is it recoverable? What is causing this
issue? and How can I avoid it in the future?
"File error: data may have been lost". Many of the cells had the inputed data
replaced with an error message #VALUE! and it appears that the data is lost.
I need to know if the data is lost, is it recoverable? What is causing this
issue? and How can I avoid it in the future?
sumardi
Nov 5, 2009, 3:17:03 AM11/5/09
to
i have the same problem, exactly as described. have any idea how to solve
this problem?
Simon Murphy
Nov 16, 2009, 3:29:46 PM11/16/09
to
That error message is normally caused by opening a .xls format file that
had some analysis toolpak functions in it.
had some analysis toolpak functions in it.
Data has been lost - some of the ATP functions will have been
overwritten with =#N/A, and the calc chain could have been corrupted
across multiple cells.
more info here:
http://smurfonspreadsheets.wordpress.com/2009/02/23/excel-2007-na-error/
Best fix is move to .xlsx or .xlsm formats, only save to .xls to send to
people without 2007.
Cheers
Simon
Excel development website: www.codematic.net
0 new messages