Can I link a local Excel file via a formula to an excel in sharepoint? RRS feed

  • Question

  • Hello:

    I am a total noob with sharepoint. If a put an excel file in sharepoint (which can be edited by several users); can I link a table in this file to "feed" a local excel file in my pc?

    Also, where could I try this for free to evaluate if it actually fits my company.


    Thank you so much!

    • Moved by Mike Walsh FIN Wednesday, March 16, 2011 7:14 AM does not seem to be asking for a programming solution (From:SharePoint - Development and Programming (pre-SharePoint 2010))
    Tuesday, March 15, 2011 9:56 PM


  • No.

    The best way of using an Excel file in SharePoint is to create a List from the Excel file (standard option when creating a list).

    However then you should abandon your Excel file completely and use only the web-based List because there is no connection between the two.

    If you want tables to be linked to a client system, use SP with Access 2007. Then there are several creation options (starting from Acccess or from SP)  which allow linking between a List and an Access table and which include syncing.

    P.S. I'm moving this to the General forum. I presume from your text that you are not interested in a programming version

    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Wednesday, March 16, 2011 7:12 AM