http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Wed, 25 Feb 2009 08:05:31 +0000 http://www.endusersharepoint.com/STP/topic/data-connection-between-lists-and-excel#post-4438 Fri, 20 Feb 2009 05:42:17 +0000 brinda 4438@http://www.endusersharepoint.com/STP/ <p>thanks for the info....will continue to use Access. </p> http://www.endusersharepoint.com/STP/topic/data-connection-between-lists-and-excel#post-4436 Thu, 19 Feb 2009 21:58:24 +0000 EndUserSharePoint 4436@http://www.endusersharepoint.com/STP/ <p>Charlie - I have no "Synchronize List" available as part of the External data toolbar.</p> <p>Here is a cut and paste from the Excel documentation stating that two way synchronization is not available between Excel and SharePoint:</p> <p>Symptoms<br /> After you export data from a Microsoft Office Excel table to a Windows SharePoint Services list, you cannot update the SharePoint list with changes that you make to the table data in Excel.</p> <p>Cause<br /> Two-way synchronization between an Excel table and a SharePoint list is no longer supported in Office Excel 2007. You can create only a one-way connection to the data in the SharePoint list, which lets you update the table data with changes that are made to the SharePoint list.</p> <p>Resolution<br /> You can use Office Access 2007 (if it is installed on your computer) or Visual Basic for Applications (VBA) code to update data on a SharePoint list so that the changes that you make to table data are reflected on the SharePoint site.</p> <p>Link: <a href="http://office.microsoft.com/client/helppreview.aspx?AssetID=HA102101091033&#38;ns=EXCEL&#38;lcid=1033" rel="nofollow">http://office.microsoft.com/client/helppreview.aspx?AssetID=HA102101091033&#38;ns=EXCEL&#38;lcid=1033</a> </p> http://www.endusersharepoint.com/STP/topic/data-connection-between-lists-and-excel#post-4419 Thu, 19 Feb 2009 17:45:34 +0000 cepes 4419@http://www.endusersharepoint.com/STP/ <p>Hi:<br /> I've had luck with the following:</p> <p>Instead of "Exporting to a Spreadsheet", a command from the Actions Menu, switch to "Edit in Datasheet" from the same menu. Assuming that you have MS Access installed on your PC, your page will appear like an Excel sheet/grid.</p> <p>Select the vertical expansion "bar" way over at the right of the list and select "Query List with Excel". This will create an Excel sheet that's connected to your List. Save the Excel sheet.</p> <p>Finally, using Excel's "External Data" toolbar (View/Toolbars), you can use the "Synchronize List" command to move data from the Excel sheeet back to the List. </p> <p>Having MS Access installed, is the key.</p> <p>Charlie </p> http://www.endusersharepoint.com/STP/topic/data-connection-between-lists-and-excel#post-4412 Thu, 19 Feb 2009 15:40:53 +0000 EndUserSharePoint 4412@http://www.endusersharepoint.com/STP/ <p>This is probably better done in Access than Excel. In SharePoint 2007, you'll notice the Access icon at the list level. With Access, you'll be able to manage it in both directions. -- Mark </p> http://www.endusersharepoint.com/STP/topic/data-connection-between-lists-and-excel#post-4406 Thu, 19 Feb 2009 15:06:10 +0000 brinda 4406@http://www.endusersharepoint.com/STP/ <p>Iam not able to update the fields to and from the List and Excel that i exported.<br /> I exported the List to Spreadsheet and how do i establish a data connection so that when i make changes and save, the values get uploaded in to the Sharepoint list.</p> <p>pls advice.... </p>