Correcting a "File error: data may have been lost" in Excel 2007

  • Thread starter Thread starter MMC Cory
  • Start date Start date
M

MMC Cory

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?
 
i have the same problem, exactly as described. have any idea how to solve
this problem?
 
That error message is normally caused by opening a .xls format file that
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FILE ERROR: DATA MAY HAVE BEEN LOST 1
Excel 2007 - File error: data may have been lost 2
excel file error + data may have been lost 1
File error: Data may have been lost 1
Excel 2007 - "File error: data may have been lost" 4
Help! Excel 2003 "Data may have been lost" error after SP3 upgrade 2
Excel Lost data when opening Excel 2003 spreadsheet in Excel 2007 0
File Error: Data May Have Been Lost 8

Back
Top