Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Upload back changes made in downloaded Excel copy to SharePoint Li
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. --- Software Engineer, Cybage Software Pvt. Ltd. Pune, India |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste into a spreadsheet that is posted to a Sharepoint site | Excel Discussion (Misc queries) | |||
copy back macro/roll back | Excel Worksheet Functions | |||
How do I copy a graph made in Excel to Word? | Excel Discussion (Misc queries) | |||
Data Upload from Excel to SQL Server | Excel Discussion (Misc queries) | |||
How can we back up a permanant copy of an excel file automaticaly | Excel Discussion (Misc queries) |