Sync a existing SharePoint list to Excel 2007

Posted on 2010-01-11
Medium Priority
Last Modified: 2012-05-08
I know MS has an add in that allows you to create a new SP list that is syncronized with the excel workbook however it doesn't allow you to syncronize excel to an existing list.  I have a well developed list that i would like to be able to edit in excel and syncronize back to the SP list.  I did some online research and it looks like 2003 has this exact functionality but 2007 only has this lame add in.  

Does anyone know of a workaround to this or do we simply need to down grade to 2003 to get the functionality back?

Question by:jonlaguna
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
LVL 16

Accepted Solution

quihong earned 2000 total points
ID: 26288883
I believe you found the best two solutions - downgrade or use the add-in.

Another solutions that is typically used, is to delete the list and have Excel push the list back to SharePoint.

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days socially coordinated efforts have turned into a critical requirement for enterprises.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question