Sharepoint 2007 Team site

[#1]

Hi,

is it possible lo LOAD an Excel file published on a intranet Sharepoint 2007 Team site?

Many thanks!

Romeo Pavoni

[amit_saini]

Hi Stefano ,

It is possible. Please follow these steps:

1. Go to your excel sheet on share point and right click for the properties.

2. Then copy the Address(Url) : http:.......(For Example)

3 . Go to your qvw file than go to back-end (ctrl +E) and select web file option and paste the copy url here .

4. This will allow you to read your excel sheet from sharpoint

[#3]

Hi Amit,

thanks for your help, i tried, the url is: http://web1ework.gruppo.mps.local/sites/SPE032/0010/prjprogesconcarser/Documenti%20condivisi/Servizi...

Immediately, under the form "File Wizard : Type" all is blank, and going forward trying to run this generated statement:

LOAD * FROM

[http://web1ework.gruppo.mps.local/sites/SPE032/0010/prjprogesconcarser/Documenti%20condivisi/Servizi...]

(ooxml, embedded labels);

it does the error: "Script error"

any clue?

[amit_saini]

Are you calling this link from Internet File option under File Wizard ?  If no then please call it through the same.

Thanks,

AS