SharePoint Services Integration with Microsoft Office

zhuyiwen

Good, Better, Best: Windows SharePoint Services Integration with Microsoft Office


Published: August 15, 2003






































Download














good_better_best.doc





126 KB


Microsoft Word file





Get Office File Viewers




















Microsoft Windows® SharePoint® Services, a component of Microsoft Windows Server™ 2003, provides tools for information sharing and document collaboration. Using Windows SharePoint Services together with Microsoft Office 2003 Editions gives users even more ways collaborate—such as Document Workspaces and Meeting Workspaces.


Download this white paper to learn how Windows SharePoint Services and Office 2003 Editions work together, and the different levels of integration between Windows SharePoint Services and Microsoft Office 2000, Microsoft Office XP, and Office 2003 Editions.


Included in this document:














•





Introduction








•





Good, Better, Best














•





Good: Microsoft Office 2000





•





Better: Microsoft Office XP





•





Best: Microsoft Office 2003 Editions





•





Comparison of Integration Features








<FONT

jhg

小弟想用SQL 链接WSS,,如何操作啊...兄弟们

zhuyiwen

zhuyiwen

WSS: Windows SharePoint Service 即 Windows 2003 的一种服务

Office SharePoint Server, 是基于 Windows SharePoint Service 的产品, 功能更加强大。

[此贴子已经被作者于2004-7-9 20:52:00编辑过]

test2000

sharepoint与wss有何不同

zhuyiwen

Comparison of Integration Features

The following tables show the integration features between Windows SharePoint Services and each version of Microsoft Office.

General Integration Features

Feature

Office 2000

Office XP

Office 2003 Editions

Save and open files from SharePoint sites

Yes (Excel, FrontPage, PowerPoint&reg;, Microsoft Project, Word)

Yes (Excel, FrontPage, PowerPoint, Microsoft Project, Visio, Word)

Enhanced (Excel, FrontPage, InfoPath, OneNote, Outlook, PowerPoint, Microsoft Project, Publisher, Visio, Word)

Create new documents in Web browser

No

Yes (Excel, FrontPage, PowerPoint, Word)

Yes (Excel, FrontPage, InfoPath, PowerPoint, Microsoft Project, Publisher, Word)

Collect metadata automatically

No

No

Enhanced (Excel, PowerPoint, Word)

Promote and demote file properties and metadata automatically

Data stored, but not displayed (Excel, FrontPage, PowerPoint, Word)

Yes (Excel, FrontPage, PowerPoint, Word)

Enhanced (Excel, FrontPage, InfoPath, PowerPoint, Visio, Word)

Track document versions

No. Use Web browser to view and manage document versions.

No. Use Web browser to view and manage document versions.

Enhanced (Excel, PowerPoint, Visio, Word)

Check-out and check-in documents

No. Use Web browser to manually check-out and check-in documents.

No. Use Web browser to manually check-out and check-in documents.

Enhanced (Excel, PowerPoint, Visio, Word). Use Web browser to manually check-out and check-in other types of documents.

Manage Microsoft Project documents, risks, and issues

No

No

Yes

Upload multiple documents

No

No

Yes

Inline discussions

Yes

Yes

Yes

Microsoft Office Components for SharePoint

No

No

Yes

Person Names Smart Tag

No

No

Yes

Integration with Microsoft Business Solutions

No

No

Yes



Document Workspace sites

Feature

Office 2000

Office XP

Office 2003 Editions

Shared attachments

No

No

Outlook attachments

<FONT face=Verdana>Create

zhuyiwen

Other New Features in Windows SharePoint Services

The following features of Windows SharePoint Services are also integrated with Microsoft Office 2003 Editions.

Improved Document Management – Windows SharePoint Services includes enhanced document management capabilities. When an Office 2003 Editions user saves a document, metadata about that document is automatically saved to the SharePoint site. Additionally, Windows SharePoint Services tracks versions of files – including Office documents – that are stored on SharePoint sites and provides document check out and check in features on the File menu in Office 2003 Editions applications.

Office Components for SharePoint Products and Technologies – Additional templates and tools that extend the features of Windows SharePoint Services are available in the Office Components for SharePoint Products and Technologies for Microsoft Office 2003 Editions. The Office Components for SharePoint Products and Technologies include templates you can use to access Microsoft Great Plains data through Windows SharePoint Services, and it includes additional data calculation Web Parts.

Person Names Smart Tag – When Office 2003 Editions are installed on a workstation, it enhances Windows SharePoint Services with the Person Names Smart Tag, which provides presence information about the availability of members of your SharePoint team wherever their names appear on a SharePoint site. This information includes whether team members are online, available for an Instant Messenger session, or able to share a whiteboard. The Person Names Smart Tag also simplifies sharing and communicating between team members by allowing users to start an e-mail message to that person and adding that person to their contacts list from within a SharePoint site.

Improved Integration with Outlook – Users typically use e-mail to share much of their work, so Windows SharePoint Services provides extensive integration with Outlook 2003. On a Contacts list or Events list SharePoint site, you can click Link to Outlook to create a read-only contact or calendar folder in Outlook 2003. This folder is synchronized with the online list whenever you use Outlook to connect to the SharePoint site. Additionally, when you receive a Windows SharePoint Services alert, the alert contains additional information that Outlook 2003 can use to run enhanced rules for sorting and filing your alerts.

Improved Integration with Excel – You can use new integration features in Excel 2003 to access, analyze and manipulate data stored on SharePoint sites. Excel 2003 provides two-way synchronization between Excel spreadsheets and SharePoint lists, so you can work with lists when you are offline and then synchronize the changes when you reconnect. Additionally, you can export Excel data to a SharePoint site as a custom list.

Improved Integration with Microsoft Access – You can now export tables from Microsoft Access 2003 to SharePoint lists, and you can import or link SharePoint lists to database tables in Access 2003.

Improved Integration with Microsoft FrontPage – You can use Microsoft FrontPage 2003 to modify and customize SharePoint sites. With FrontPage 2003, you can manage list views, edit pages, add Web Parts to pages, and design templates for SharePoint sites. FrontPage 2003 also includes reporting capabilities that you can use for tracking and reporting site page data and usage statistics.

Create Data Driven Web Parts – You can also use FrontPage 2003 to create data-driven Web Parts that connect to a variety of back-end data sources and present that data live on your SharePoint site.

<FONT face=Verdana>Solution Packages – You can use FrontPage 2003 to create site solution packages that can be easily deploye

zhuyiwen

Good, Better, Best: Windows SharePoint Services Integration with Microsoft Office

White Paper

Published: July 2003



For the latest information, please see http://www.microsoft.com/sharepoint/Introduction

Microsoft&reg; Windows&reg; SharePoint™ Services is a component of Microsoft Windows Server 2003 that provides tools for information sharing and document collaboration that users and teams can use to work together with speed, security, and flexibility. This paper focuses on integration between Windows SharePoint Services and Microsoft Office 2003 Editions. Other server products that build upon the Windows SharePoint Services foundation, such as Microsoft Office SharePoint Portal Server 2003, also make use of the features and technologies described in this paper. Windows SharePoint Services and SharePoint Portal Server 2003 comprise the latest version of Microsoft SharePoint Products and Technologies, a powerful set of tools for organizing information, managing documents, and providing efficient collaboration tools that are easy to use.

The collaborative tools provided by Windows SharePoint Services are easy to use, so you can share files and information and communicate more effectively with your coworkers. You can easily create and use SharePoint sites for any purpose. For example, you can create a site to serve as the primary Web site for a team, or you can build a site to help users meet short-term or long-term shared work goals. A typical SharePoint site might include a variety of useful tools and information, such as shared document libraries, contacts, calendars, task lists, discussions, and other powerful information sharing and visualization tools.

Sharing documents and information is only part of what you can do with Windows SharePoint Services. Microsoft Office is closely integrated with Windows SharePoint Services, so you can use features from Windows SharePoint Services in your Office applications. Many important Windows SharePoint Services features are integrated with Office menus and features. You can even create SharePoint sites from your Office applications as part of your regular work routine, so you can be more productive without needing extensive training or specialized technical knowledge.

This paper describes how Windows SharePoint Services and Microsoft Office work together. Additionally, it describes the different levels of integration between Windows SharePoint Services and Office 2000, Office XP, and Office 2003 Editions. Office 2000 provides very basic integration with Windows SharePoint Services, and Office XP provides some additional integration features. However, Office 2003 Editions provide enhanced integration with Windows SharePoint Services. Good, Better, Best

Windows SharePoint Services and Microsoft Office are natural partners in a productive, connected computing environment. Microsoft is committed to integrating the power of work-sharing tools and the Web into the productivity applications that most users already know. Microsoft Office 2000, Microsoft Office XP, and Microsoft Office 2003 Editions represent increasing levels of integration between the Microsoft Office suite and Windows SharePoint Services.

·         File Save Integration – Microsoft Office 2000 provides basic integration with Windows SharePoint Services. Users can open and save files stored on SharePoint sites from their Office 2000 applications and receive alerts in Microsoft Outlook&reg; 2000.

<FONT face=Verdana>·         Basic Data Integration – Microsoft Office XP provides additional data integration between SharePoint sit

test2000

看，不错，谢谢，新东西，要学学。

zhuyiwen

在工作组模式中也可以使用，能与Office 2003紧密集成。