M
Matteo
Hi, 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 as of Tuesday. Any ideas?
Thanks, Matt
(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 as of Tuesday. Any ideas?
Thanks, Matt