Ask Experts Questions for FREE Help !
Ask
    jakester's Avatar
    jakester Posts: 582, Reputation: 165
    Senior Member
    		  
    #1

    Aug 8, 2011, 09:57 AM
    How to link to Excel table in Sharepoint
    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.
    NeedKarma's Avatar
    NeedKarma Posts: 10,635, Reputation: 1706
    Uber Member
    		  
    #2

    Aug 8, 2011, 10:13 AM
    Quote Originally Posted by jakester View Post
    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.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Aug 8, 2011, 05:03 PM

    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search


Check out some similar questions!

Link tab in excel? [ 2 Answers ]

I have a huge excel file I was hoping to create a list on one tab. When I click EMEA or America, I want the data & graph to appear. I think I need to link the various data tabs to the one with the list box How do I achieve this?

How to link excel sheet? [ 2 Answers ]

How to link the excel cells with next colums so that when we miss any colums to fill then we don't hv write to fill next colums

Link of excel sheets [ 1 Answers ]

Link excel speadsheet

How to link to other spreadsheets using Excel [ 2 Answers ]

How do you compose a spreadsheet to link information that has been inputted into that spreadsheet to reflect on other spreadsheets?

View more questions Search