Open an Excel file, it prompts 'Data may be missing'

[Happy]

I got an Excel file (contain Chinese characters) with more than 36825 rows in
a single worksheet. I'm using the Chinese (Traditional) version of Excel.

This file, when opened with Excel 2007 (12.0.6504.5001) SP MSO
(12.0.6425.1000), it shows pop-up message '檔案錯誤 資料å¯èƒ½éºå¤±' (Translated into
English, it means, "file in error: data may be missing"). The same message
appeared when opened with Excel 2003 (11.8231.8221) SP3.

I've no idea what the message really means, 'cos the content seems to be
complete and correct.

How can I open the file without the message?

An additional info., the same file can be opened with Excel 2003
(11.8307.8221) SP3 successfully.

 

[Simon Murphy]

Happy
The 'Data may be lost' error refers to Analysis Toolpack Functions
(=EOMONTH(), NETWORKDAYS() etc) that have probably been replaced with =#N/A.
do a search for that in the opened file.
This is a known issue with .xls in Excel 2007. Not sure if there is a
fix available, but I'm pretty sure SP2 doesn't fix it. it doesn't happne
with .xlsm.

more info here:
http://smurfonspreadsheets.wordpress.com/2009/02/23/excel-2007-na-error/

Cheers
Simon
Excel development website: www.codematic.net