In Excel 2003, you can connect to (read from) and update (write to) lists that reside on SharePoint (WSS 2.0 or WSS 3.0) sites. This allows you to keep the information in your Excel 2003 tables synchronized with the information that appears on the SharePoint site.
In Excel 2007, the ability to update the information in SharePoint lists from Excel is deprecated. Instead, Access 2007 is the recommended platform for writing data to SharePoint lists and for using lists offline. Unfortunately, this upset many Excel 2003 users to the point of being unwilling to upgrade to Excel 2007.
Specifically, in Excel 2007, the ability to update SharePoint lists changed in the following ways:
- Existing files from Excel 2003 load and continue to support update functionality when opened in Excel 2007.
- Lists that link to a SharePoint site are converted to read-only tables when you save existing files to the new Open XML file formats.
- It is still possible to publish a table to SharePoint lists; however, this is a one-time write operation to SharePoint.
The good news is that an Excel 2007 Add-in for Synchronizing Tables with SharePoint Lists has just been released by Microsoft! This add-in allows you to publish a read-write list to a SharePoint list. However, the trade-off is that that you cannot save the workbook in the new Office Open XML Formats. Instead, to retain the functionality, you need to save the workbook in the Excel 97-2003 (Biff8) file format.
For more information, go here.
<Lawrence />
>>Source Link
>>Blog: Microsoft SharePoint Products and Technologies Team Blog
>>Publish Date: 6/23/2007 7:13:36 AM
>>Keywords: excel sharepoint
Related Posts
>>Excel Services Settings (MOSS 2007) #
Excel Services Settings Excel services have to be setup properly in SharePoint Central Administration before they are used in SharePoint. New users often forget to set these settings in central admini
>>Links to resources on Excel Services #
As part of my new role, I"m learning more about Excel Services and the ability to render spreadsheets on the server. Excel Services is available through the Microsoft Office SharePoint Services SKU. H
>>Collaborating on Excel files #
Every once in a while I ran into customer who wants to use SharePoint as collaboration platform for information workers working on Excel files. The only problem here is that these customers need to al
>>Simple Excel Services - Step by step, publishing a spreadsheet to SharePoint 2007 #
In this post I will briefly describe how you can connect your excel spreadsheet to a SharePoint list using Excel Services.I will not go into any details as to what Excel Services is, how you get it on
>>How to edit an excel file using Excel Web Access #
When I first saw Excel Web Access (the ability to convert Excel documents to web pages on Sharepoint 2007) I was very exciting. However when I realized that one cannot edit a spreadsheet from a brows
>>The fix for: Method Post Error in Excel 2007 Import Spreadsheet #
Have you tried importing a Excel 2007 spreadsheet into SharePoint Service v3 and are getting a Method Post Error? Thanks to an open SharePoint forum, someone posted the fix. I take no credit for this
>>Use Excel 2007 to Read and Parse SharePoint 2007 Logs #
Ever get tired of trying to read and make sense of the MOSS 2007 Logs? Or any text-based logs for that matter? Use Excel 2007 to open and import the logs. You can then filter and browse the logs in
>>Embed a dynamic excel spreadsheet and chart object into web part #
A customer of mine called in with this requirement of embedding a dynamic excel spreadsheet and chart object into a SharePoint (both V2 and V3) web part. After few hours of battle, we came up with the
>>SharePoint Load Tests #
The MOSS perf team (I think it stands for Microsoft Office Server System) just released sample web tests and load tests for testing Windows SharePoint Services, Office SharePoint Server, and Excel Ser
>>Using Analysis Services data in Excel Services part 3 - Create and test an Excel sheet #
This is the third and last part in a small series on my adventures to get Excel Services working with SQL Server 2005 Analysis Services. In this part we will create and test an Excel sheet. Part 1 &nd