ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Update back to shaprepoint list from dowloaded Excel file (https://www.excelbanter.com/excel-discussion-misc-queries/159188-update-back-shaprepoint-list-dowloaded-excel-file.html)

Amitabh

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