Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
i want to update one excel file the other one update automaticaly Basant New Users to Excel 1 December 16th 06 12:50 AM
I have saved over the top of my excel file and want to get it back Kerry Excel Discussion (Misc queries) 1 July 17th 06 01:48 PM
After failed update download, how can I bring back Excel? Virginia Excel Discussion (Misc queries) 2 December 20th 05 01:39 PM
Have Windows XP Dowloaded. Can't find Office or Excel. wannalearn Setting up and Configuration of Excel 1 September 21st 05 02:30 AM
SAVE is not available in Excel under FILE. How do I get it back? ldk Excel Discussion (Misc queries) 7 July 25th 05 09:59 PM


All times are GMT +1. The time now is 12:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"