Synchronizing an Excel file with SharePoint


To install add-in for use in office Excel 2007
Download and install the Excel 2007 Add-in : Synchronizing Tables with SharePoint Lists.
·        
  •       Start Office Excel 2007.
    •          Click the Microsoft Office Button, Click Excel Options, and then click the Add-ins tab.
    •          Select Excel Add-ins in the Manage drop-down list and click Go.
    •          In the Add-ins dialog box, click Browser, navigate to the Excel 2007 SharePoint List synchronizing Add-in, and then click Ok.
    •         In the Add-ins dialog box, verify that the SynchronizeWSSandExcel option is selected and then click Ok.
    Figure 1. The Add-Ins dialog with the Rwsplist option selected


    Publishing and Synchronizing Table Data to a Sharepoint Site
    Using the add-in is simple, as you see in the following steps.
    •          To add the add-in to a workbook Save the workbook in the Excel 97-2003 file format by clicking the Microsoft Office Button, Pointing to Save As, and them clicking Excel 97-2003 Workbook.
    •          Specify a file name, and then click Save.
    •          Convert the range of data to a table: Highlight the table, choose Insert, Table, confirm the range for the table is correct, choose Ok.
    •          To publish the table to a SharePoint list: Highlight the table. The Table tools label is display above the design tab.
    •          Click the design tab.
    •          In the SharePoint group, click Publish and allow Sync.
    Figure 2. The publish and allow Sync button on the Design tab

    • In the Export Table tp Sharepoint R/W List dialog box, in the Address text box, type in the page address on the SharePoint site where you want to publish the list.
    Figure 3. The Export table to SharePoint R/W List dialog box

    In the Name text box, Type in the name of the list and, optionally, type a description for the list.
    Click Publish and navigate to the page that you specified earlier in Sharepoint site and verify that the list published.

    To update the SharePoint list
    ·         In the table in the work, make the changes to the data.
    ·         With the pointer in the table, right-click, point to table, and click Synchronize with SharePoint.
    Figure 4. the synchronize with SharePoint option

    In the Browser, Refresh the list and observe that the list reflects the changes.
    Conclusion
    Although the ability to update SharePoint list from Office Excel 2007 is deprecated in favor of publishing and synchronizing lists using Office Access 2007; you can use the Excel 2007 SharePoint List Synchronizing add-in to update SharePoint lists from Office Excel 2007.


    J Selamat Mencoba J
    J“Ilmu terus berkembang teruslah mencari dan mengexplore”J

    Komentar

    Posting Komentar

    Postingan populer dari blog ini

    You cannot view a list in Datasheet view on a SharePoint

    You cannot view a list in Datasheet view on a SharePoint website after you install the 64-bit version of Microsoft Office 2010.  When you click  Actions  and then click  Edit in Datasheet  on a SharePoint 2003 or 2007 site, or you click the  List  tab and then click  Datasheet view  on a SharePoint 2010 site, you receive the following error message: The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Microsoft SharePoint Foundation is not installed. Your Web browser does not support ActiveX controls. A component is not properly configured for 32-bit or 64-bit support. to solve this problem you can download this :  2007 Office System Driver: Data Connectivity Components
    Baca selengkapnya

    CAML query with nested AND's and OR's for multiple fields in SharePoint

    I have some cases about CAML in SharePoint. there are how to make condition like this : AND ( FirstName = 'A' OR LastName = 'A' OR Description = 'A' OR Profile = 'A' ) AND ( FirstName = 'B' OR LastName = 'B' OR Description = 'B' OR Profile = 'B' ) in SharePoint we use CAML if we want to see "AND OR" condition in sharepoint list view.  open your page of view what your want to edit. for example AllItem.aspx under form in document library. but before that you should set first condition "AND OR" in view you want to edit using sharepoint designer. Since you are not allowed to put more than two conditions in one condition group (And | Or) you have to create an extra nested group ( MSDN ). The expression  A AND B AND C  looks like this: <And> A <And> B C </And> </And> it is sample translated to CAML (hopefully with ...
    Baca selengkapnya