![]() |
Update back to shaprepoint list from dowloaded Excel file
Hi
I am having a client requirement that user can download Excel/Access file from SharePoint list, do some changes in Excel/Access file and upload it back to the same SharePoint list. I am working on <bSharePoint 2007</b and <bOffice 2007</b. A user is not able to see all the records in his view, filters are applied on <bAssigned To</b column condition is <bAssigned To = [Me] </bon View. I am using <bExport to spreadsheet</b option present inside <bAction</b Menu at top of Sharepoint list. But When I opened the downloaded Excel file, I found that it can only be Refresh from SharePoint list but cannot be updated back. An Export option is in there in Excel but that creates a new SharePoint list which is not my solution. <bOpen in Access</b option is also in there but it returns me all records present in SharePoint list, some of the records I dont want a particular user should be seeing or editing. Can anyone help me by telling Is there any way to update back changes to same SharePoint list ? I am ready to write any code to achieve this requirement. -- Software Engineer, Cybage Software Pvt. Ltd. |
All times are GMT +1. The time now is 08:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com