Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel SharePoint 2003 Integration
Hello All
Our company wants to setup a Excel workbook online for multiuser. The assigned user can add/delete/etc and save online connecting to our office server. Our office server is SBS 2003 with SharePoint installed. I need to know if I can setup the Excel with SharePoint 2003 so multi users can access the workbook and edit it and save. How can I accomplish this task on our existing server and what are other alternatives if it cannot be done with our existing server. Many Thanks€¦ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel SharePoint 2003 Integration
Hi,
Synchronize an Excel list with the SharePoint site When you publish a list and choose to link the list, you must manage synchronization between the local Microsoft Excel list and the SharePoint list. The List toolbar provides two buttons that allow you to choose how you wish to handle updates to the list data. Synchronize List On the List toolbar, click Synchronize List to publish any local changes to the SharePoint list, and bring any changes made to the SharePoint list down to the local Excel list. If changes you make in Excel conflict with changes made by another user on the SharePoint Site, Excel displays the Resolve Conflicts and Errors dialog box. You can do one of the following: A. Resolve each conflict individually To use the changes made by another user to the list on the SharePoint Site, click Discard My Changes. To override the changes made by another user to the list on the SharePoint Site, click Retry My Changes. B. Resolve all conflicts at once To use all changes made by another user to the list on the SharePoint site, click Discard All My Changes. To override all changes made by another user on the SharePoint site, click Retry All My Changes. C. Unlink the lists To remove the link to the SharePoint List, click Unlink My List. You can continue to make changes to your list in Excel, but you will no longer be able to synchronize with the list on the SharePoint site. Discard Changes and Refresh On List toolbar, click Discard Changes and Refresh to discard local changes to the list and download the current copy of the list from the Microsoft Windows SharePoint Services Web site. Note Synchronization is not automatic. Unlike a standard link in Excel (that is, between two cells), you must manually synchronize or discard local changes to the list. This is important because you are not prompted to do anything with local changes to a linked list when the file is saved or closed. You are only notified that the file has unsynchronized local changes when the file is opened. Challa Prabhu "xtone-hari" wrote: Hello All Our company wants to setup a Excel workbook online for multiuser. The assigned user can add/delete/etc and save online connecting to our office server. Our office server is SBS 2003 with SharePoint installed. I need to know if I can setup the Excel with SharePoint 2003 so multi users can access the workbook and edit it and save. How can I accomplish this task on our existing server and what are other alternatives if it cannot be done with our existing server. Many Thanks€¦ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel SharePoint 2003 Integration
Hi Prabhu
Thanks for your advice. I was using SharePoint 2 and now I upgraded to SharePoint 3. But I cannot follow the steps you mentioned in your notes. I could not find the toolbar in my SharePoint and so if you can please advice further in detail how to set up the Excel in SharePoint 3 for multiusers. Many thanks... "challa prabhu" wrote: Hi, Synchronize an Excel list with the SharePoint site When you publish a list and choose to link the list, you must manage synchronization between the local Microsoft Excel list and the SharePoint list. The List toolbar provides two buttons that allow you to choose how you wish to handle updates to the list data. Synchronize List On the List toolbar, click Synchronize List to publish any local changes to the SharePoint list, and bring any changes made to the SharePoint list down to the local Excel list. If changes you make in Excel conflict with changes made by another user on the SharePoint Site, Excel displays the Resolve Conflicts and Errors dialog box. You can do one of the following: A. Resolve each conflict individually To use the changes made by another user to the list on the SharePoint Site, click Discard My Changes. To override the changes made by another user to the list on the SharePoint Site, click Retry My Changes. B. Resolve all conflicts at once To use all changes made by another user to the list on the SharePoint site, click Discard All My Changes. To override all changes made by another user on the SharePoint site, click Retry All My Changes. C. Unlink the lists To remove the link to the SharePoint List, click Unlink My List. You can continue to make changes to your list in Excel, but you will no longer be able to synchronize with the list on the SharePoint site. Discard Changes and Refresh On List toolbar, click Discard Changes and Refresh to discard local changes to the list and download the current copy of the list from the Microsoft Windows SharePoint Services Web site. Note Synchronization is not automatic. Unlike a standard link in Excel (that is, between two cells), you must manually synchronize or discard local changes to the list. This is important because you are not prompted to do anything with local changes to a linked list when the file is saved or closed. You are only notified that the file has unsynchronized local changes when the file is opened. Challa Prabhu "xtone-hari" wrote: Hello All Our company wants to setup a Excel workbook online for multiuser. The assigned user can add/delete/etc and save online connecting to our office server. Our office server is SBS 2003 with SharePoint installed. I need to know if I can setup the Excel with SharePoint 2003 so multi users can access the workbook and edit it and save. How can I accomplish this task on our existing server and what are other alternatives if it cannot be done with our existing server. Many Thanks€¦ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronize excel 2003 to sharepoint 2007 | Excel Discussion (Misc queries) | |||
Excel integration with databases | New Users to Excel | |||
Excel through Sharepoint 2003 problem | Excel Discussion (Misc queries) | |||
Subtotals in Excel 2003 for doc exported from Sharepoint list | Excel Discussion (Misc queries) | |||
Office 2003 integration - Great Plains | Excel Discussion (Misc queries) |