How to Update a SharePoint list
I have an Excel 2007 spreadsheet that is updated by a download from another system. I want to update my SharePoint List every two weeks with current data uploaded in the spreadsheet. When I re-upload the spreadsheet, it creates a separate list.
I thought I could just delete the original list and rename the new one with the old name. However, when I delete the original list, it messes up my web part that displays the filtered data from the list. I have a filtered list on several documents
that comes from the same list. The web part doesn't "link" with the new list so it doesn't show the updated information. Is there a way to just update the information in the original list every two weeks so the correct data will display in the
web part?
December 8th, 2010 4:49pm
You can sync SP 2007 Lists with Access 2007 tables.
So you can extend your search to see if it is possible to amend an Access table based on changes in an Excel 2007 spreadsheet.
OOB it isnt possible to sync Excel 2007 changes with a List created from the same Excel 2007 spreadsheet because the creation of the List (from the spreadsheet) is a one-off.
Note: If it were up to me I would look at the "updated by a download from another system" and see if this can be amended to instead update an Access table. I don't see from your text that you actually need to have a spreadsheet as the recipient of that
update.
SP 2010 "FAQ" (mainly useful links):
http://wssv4faq.mindsharp.com/default.aspx
WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
Both also have links to extensive book lists and to (free) on-line chapters
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2010 1:23am