SharePoint Services Integration with Microsoft Office

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

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

test2000

sharepoint与wss有何不同

zhuyiwen

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

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

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

zhuyiwen

jhg

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