 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / March 2008Open file
I export SPSS file to Excel. When I open this file in Excel I have warning: FILE ERROR: DATA MAY HAVE BEEN LOST. What does this mean ? > I export SPSS file to Excel. When I open this file in Excel I have warning: > FILE ERROR: DATA MAY HAVE BEEN LOST. What does this mean ? I guess it means what it says. Which version of Excel? How does the data get to Excel? - does SPSS open Excel for you and put the data in a worksheet - or does it generate a file which you then open in Excel - if so, hat is the format of the exported file: CSV, XLS or some other format? - or some other method? Do you get to see the data in Excel? - if so, does the data appear to be complete and correctly arranged - If not, can you describe how it looks and how that differs from what you expected? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup I use Excel 2007. SPSS 13.0 generate the exported file .XLS. I open this file in Excel 2007 with warning FILE ERROR: DATA MAY HAVE BEEN LOST. I see the file and data is correctly arranged. > > I export SPSS file to Excel. When I open this file in Excel I have warning: > > FILE ERROR: DATA MAY HAVE BEEN LOST. What does this mean ? [quoted text clipped - 18 lines] > MVP - Microsoft Excel, Oxford, England > No email replies please - respond to newsgroup Well, I guess the Excel file produced by SPSS is not quite correctly organised, at least as 2007 sees it. Do you have any earlier versions of Excel available to see if it opens correctly in an earlier version? If so then it looks like a compatibility problem in 2007; otherwise it looks like an SPSS problem. If the data is all present and correct then I guess you could just ignore the message. Alternatively, if SPSS allows export in different formats that can be read by Excel, try one of the others. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup Thanks for replying mr. Bill. Excel 2003 is open the file without warning. I guess in the file is any small problem and it's not problem in Excel 2007. > Well, I guess the Excel file produced by SPSS is not quite correctly > organised, at least as 2007 sees it. [quoted text clipped - 12 lines] > MVP - Microsoft Excel, Oxford, England > No email replies please - respond to newsgroup Hi, I believe I am having a similar issue. I have a Windows Sharepoint Services 2007 list I export to Excel 2003 (SP3 11.8206.8202). Sharepoint creates an .iqy file and I open it in Excel. This creates a List range in the spreadsheet that is tied to the Sharepoint List (I make batch updates to the list, right-click and synch the list with the server, works fine). I save the workbook to my PC as .xls. When I open it later I get the error "File Error: Data May have been Lost", the list data is still there but the range is not i.e. the list range no longer has a blue border around it and I can no longer right-click and Synchronize List. It's like the link to the Sharepoint list was destroyed when I saved the file. I've been doing this process reliably for a while, It started consistently erroring today. Any ideas? Thanks! > Thanks for replying mr. Bill. > [quoted text clipped - 18 lines] > > MVP - Microsoft Excel, Oxford, England > > No email replies please - respond to newsgroup
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.