I have always been able to export a list in sharepoint to a spreadsheet. But after we moved the portal to Sharepoint 3, I am able to export it but when I try to open the web query file in my excel, it tells me: "Data could not be retrieved from the database".
Other details:
I have MS Excel XP
I have all the web components installed
I have all the office tools installed, included the tools for WSS
Yet, it still won't work.
Any clues?
Lina
Start Free Trial