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 ?

Zoran Banai wrote:
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.

"Bill Manville" wrote in message
...
Zoran Banai wrote:
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

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.

"Bill Manville" wrote in message
...
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

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!

"Zoran Banai" wrote:

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.

"Bill Manville" wrote in message
...
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