Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
i want to update one excel file the other one update automaticaly | New Users to Excel | |||
I have saved over the top of my excel file and want to get it back | Excel Discussion (Misc queries) | |||
After failed update download, how can I bring back Excel? | Excel Discussion (Misc queries) | |||
Have Windows XP Dowloaded. Can't find Office or Excel. | Setting up and Configuration of Excel | |||
SAVE is not available in Excel under FILE. How do I get it back? | Excel Discussion (Misc queries) |