A
Amitabh
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 SharePoint 2007 and Office 2007.
A user is not able to see all the records in his view, filters are applied on
Assigned To column of List, condition is Assigned To = [Me] in View.
I am using Export to spreadsheet option present inside Action 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 an altogether new
SharePoint list which is not my solution.
Open in Access 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.
Any help is much appreciated.
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 SharePoint 2007 and Office 2007.
A user is not able to see all the records in his view, filters are applied on
Assigned To column of List, condition is Assigned To = [Me] in View.
I am using Export to spreadsheet option present inside Action 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 an altogether new
SharePoint list which is not my solution.
Open in Access 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.
Any help is much appreciated.