Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open an Excel file, it prompts 'Data may be missing'
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open an Excel file, it prompts 'Data may be missing'
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 he http://smurfonspreadsheets.wordpress...2007-na-error/ Cheers Simon Excel development website: www.codematic.net Happy wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file prompts: open or save? | Excel Discussion (Misc queries) | |||
I can't open up a file, its says I'm missing xlr.. what is that | Excel Worksheet Functions | |||
Open the file or save it - missing | Excel Discussion (Misc queries) | |||
excel won't open, keeps saying installation file missing? | Excel Discussion (Misc queries) | |||
When saving CSV excel always prompts about the file format | Excel Discussion (Misc queries) |