While working on an expense report in Excel 2010 tonight, a crazy idea dawned upon me “Hmm, I wonder if I can install the Excel 2007 Add-in that allows me to sync an Excel table to a SharePoint list in Excel 2010 … ” Long story short, it worked!
I was overjoyed (do you hear Stevie Wonder in the background
?) that tears started to fall … OK, OK, enough of the drama. Here are the steps on how you can synchronize an Excel 2010 spreadsheet to a SharePoint 2010 list:
1. Make sure you have Excel 2010 installed on your machine (just makin sure).
and install “Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists” to your copy of Excel 2010.
3. Create or open an Excel Spreadsheet (make sure the file is saved as .XLS)
5. In Excel 2010, from the Design tab, click Publish and allow Sync
6. Enter the SharePoint site URL, list name and description
7. Click Publish
That’s it! You can now update either the Excel spreadsheet or SharePoint list and it will be in sync. Make sure you manually sync Excel with SharePoint by right-clicking within the Excel table and select Table | Synchronize with SharePoint.
Lastly, if you are wondering, you can do this with SharePoint Foundation 2010. You won’t need Excel Services 2010 at all.