XML Support in Excel and Access
Excel now supports Extensible Markup Language (XML). Users can load and save generic, well-formed, and spreadsheet XML directly into Excel. Furthermore users can query XML spreadsheets from the Web and thereby analyze important Web data.
Access users can easily import or export XML schema and data documents into and out of Access. Users can automatically import the XML tables or access advanced options to customize the import. Similarly, when users export XML data, schema, and presentations, they can leave the defaults as they are, or they can select advanced options for greater control over the exported output.
- Example: In Excel, choose Save As from the File menu.
- From file-type drop-down menu, select XML Spreadsheet. The Excel files can have Indian language data.
Intelligent Setup
When upgrading from a previous version of Office, Setup analyzes a user’s current configuration and intelligently installs the same components.
Office XP has made a variety of improvements on its interaction with Windows Terminal Server. For example, installation is made simple because administrators can simply run setup when installing Office XP rather than needing a custom transform. Furthermore, certain complex graphics such as menu fading and smooth scrolling are turned off automatically when a user is connected to a remote machine. This creates an improved application performance for the user.
Support for Windows Terminal Server
Office XP has made a variety of improvements on its interaction with Windows Terminal Server. For example, installation is made simple because administrators can simply run setup when installing Office XP rather than needing a custom transform. Furthermore, certain complex graphics such as menu fading and smooth scrolling are turned off automatically when a user is connected to a remote machine. This creates an improved application performance for the user.
Document Subscriptions
Office users can subscribe to documents and folders, and they can even search and categorize their subscriptions. Readers or authors can express interest in a particular document, folder, search, or category and be notified (via SMTP mail or through a central Web site) when there has been a change. Notifications can fire immediately or be batched within a particular interval.
File Menu Additions
The file menu in Office applications is enhanced to allow documents to be checked in, checked out, and submitted for publication without ever leaving Office. Microsoft SharePoint Portal Server document libraries are directly visible and navigable in the Office 2000 Open/Save dialog boxes.
Document Versioning
Edited Office documents are tracked so that previous versions can be retrieved. Versioning is used for two reasons—audit and recovery. Audit is used to find out who changed a document, when it was changed, and what was changed. Recovery is used when a user wants to revert to a previous version of a document.
Document Profiling
Document Profiling allows users to associate attributes with their Office documents, making them easier to find, organize, and act on. These profiles can be configured on a per-folder basis, and profile requirements can be set for each folder.
Document Retrieval
Once Office documents are placed into a Microsoft SharePoint Portal Server, they can be retrieved based on content, location, keywords or phrases, document profile, and attribute information. All versions of a document can be retrieved.
Furthermore, users who do not have access to a document or do not have access to a draft document do not see it returned in search results.