I have an Excel Workbook that's located on our Sharepoint site. I'd like to create a linked table to that file but I can't seem to get it to work correctly.

I was able to link to the Sharepoint List where the file is located but I don't know how to manipulate the worksheet: really what I want to do is to query the linked table and report on it.

Thanks.

Quote:

---

Originally Posted by jakester

I'd like to create a linked table to that file

---

Is that linked table on your local computer?
This isn't my forté but if you have a Access table on your local computer/shared drive you may not be able to link/have interactivity to a file that behind a username/password protected area.

I'm sure Scott will be able to shed some light on this.

As I understand Sharepoint you can't. You can link both Access and Excel to Sharepoint lists, but if a file is stored in a Sharepoint document repository, I don't believe you can link to it.

One possibility depends on whether your Sharepoint server is locally hosted or not. If it is, you may be able to create a network share for the repository and link to it that way.