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