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.
|