In This Chapter
Improved Software Administration
Intelligent Applications
Intranet and Workgroup Solutions

This chapter provides a brief description of the most exciting new features in the Office family of applications. Office 97 for Windows and Office 98 for the Macintosh combine intelligent applications with the power of intranet solutions to provide significant business advantage to your organization. These new Office features:

• Help users complete tasks in less time and with less effort.

• Create and manage intranet content and work with intranet data.

• Make Office easier to set up, configure, and support.

For a large organization, the decision to upgrade or switch software is based primarily on what it takes to make the change. Issues that affect this decision include how easy it is to deploy and administer the software, whether existing hardware supports it, and whether users with different versions of the software can work together. Office 97 (Windows) and Office 98 (Macintosh) provide features, tools, and documentation that support the administrator in this transition.

Because many users share documents across platforms, Office 98 for the PowerPC­based Macintosh provides the same file formats as Office 97 for Windows. Both versions of Office provide a similar interface and common functionality, including built­in intelligence features, integration with the World Wide Web, and collaboration tools.

In some cases, Microsoft has made changes in Office 98 to enhance support for Macintosh users. However, the similarity between the Office 98 and Office 97 versions is good news for organizations that support both the Macintosh and the Windows platform and are planning a migration to the new versions of Office.

Office 97 Setup

For More Information   about running the Office 97 Setup program, see Chapter 4, "Installing Microsoft Office."

Office 98 Installation

Office 98 also has another feature that makes it easier for network administrators to manage a user's desktop — self-repairing applications. If a user moves or accidentally deletes shared libraries, Office 98 detects the changes, notes the new locations, and adjusts accordingly. If users want to move the Office folders after installation, they can just drag and drop the folders to a new location. Office 98 automatically updates all of the preference settings to reflect changes made by users.

For More Information   about running the Office 98 Installation program, see Chapter 4, "Installing Microsoft Office."

Enhanced Integration with the Macintosh Interface

For example, Office 98 now supports:

• Contextual menus, which remain open even when the user is not pressing the menu title.

• Platinum Appearance controls, like those in the new Apple® Mac OS 8.

• A WYSIWYG font menu in Microsoft Word 98.

In addition to looking and behaving more like a software suite designed for the Macintosh, Office 98 also significantly improves support for Apple technologies. For example, because QuickTime and QuickTime VR support are built into the Office 98 drawing tools, it is easy to insert QuickTime movies or QuickTime VR panoramas in any Office document.

Office 98 also follows the Apple Platinum Appearance specification and supports Macintosh Drag and Drop, which makes it easier to share information across the Office applications, the Macintosh system, and third-party programs. For example, users can now drag a Microsoft Excel 98 spreadsheet to the desktop or into another application, such as Word 98.

System Policy Templates

Note   Windows NT Workstation version 3.51 and the Macintosh do not support system policies.

Office 97 supports system policies in two ways: first, most of the user settings are stored in the Windows registry; and second, you can determine user settings (such as the default folder or format for saving files) using a set of policy templates that come with the System Policy Editor.

For More Information   about using system policies, see "Using Windows System Policies to Customize Office" in Chapter 7, "Customizing and Optimizing Microsoft Office."

Network Installation Wizard

The Network Installation Wizard is used to create custom Setup scripts. It looks and operates like an Office wizard, and prompts you to determine whether the users will run the software from their hard disks or from a network server; what features to include; and how the program items should appear on the Start menu or in Program Manager.

For More Information   about using the Network Installation Wizard, see "Modifying Client Setup with the Network Installation Wizard" in Chapter 6, "Customizing Client Installations."

Microsoft Systems Management Server

The package definition file (PDF) is the set of instructions that Systems Management Server uses to distribute the software. When used with the batch file options for Office Setup, it is possible to perform a customized installation of Office on all desktops in your organization from one central location. When Setup is complete, the message information file (MIF) for Systems Management Server records an entry in your Systems Management Server database about whether the installation was successful or whether errors occurred.

For More Information   about using Systems Management Server, see ""Using Microsoft Systems Management Server to Install Office" in Chapter 6, "Customizing Client Installations."

Office 97 Upgrade Wizard

For More Information   about using the Office Upgrade Wizard, see "Using the Office 97 Upgrade Wizard" in Chapter 9, "Troubleshooting Installation."

File Format Compatibility

Because some of the file formats for Office have changed since Office 4.x and Office 95, Office 97 (Windows) and Office 98 (Macintosh) include features that make it easier for users to work together when using different versions of Office.

Default Save

Users can determine which file format to use as the default when saving a file. A Microsoft Excel 97 user who shares files with an Excel version 5.0 user may choose Excel 5.0 format, while another user who does not often share files may choose to stay with Excel 97 format. You can also set the default format for all Office applications in your organization using a system policy in Windows 95 or Windows NT Workstation 4.0, or by using custom Preference files on the Macintosh.

For More Information   about the default format to use when saving an Office document, see "Specifying the Default Format in Which to Save Office Documents" in Chapter 22, "Supporting Multiple Versions of Microsoft Office."

New File Converter Architecture

Office 97 and Office 98 implement a new file­converter architecture to make mixed environments easier to work with. This new architecture stores file converters in a network location so new converters can be deployed without having to touch every desktop.

Each new version of Office is aimed at making it easier for users to get their work done, while reducing the strain on your help desk. Built into every application is IntelliSense® technology, which automates repetitive tasks, simplifies complex tasks, personalizes the software, and makes the functionality in the products more accessible.

Intelligent Applications in Office

Office includes several enhancements to make it easier to use. Some of these enhancements are described in this section.

Office Assistant

The role of user assistance in Office has evolved over time. Initially, the goal was to document every feature and its use in a printed manual. However, since many people did not have the time to read that documentation, user assistance was gradually integrated into the product. Previous versions of Office put more information into online Help, making it easier to find particular topics. Added features included Cue Cards, which stay on-screen while you use them, and the TipWizard®, which watches what you do and suggests an easier way to accomplish specific tasks.

While these innovations advanced users' abilities to work with Office, customer feedback and a series of research projects indicated the need for a fresh approach to online assistance. The Office Assistant is based on the familiar figure of the departmental expert; this feature allows you to ask questions in everyday language. The Assistant serves as the central place to unify all user assistance in all the Office products and is appropriate for all levels of users and for users around the world. The Assistant is shown in the following illustration.

Some of the ways in which the Assistant can help include:

• Natural language assistance

  When you ask the Assistant a question in everyday language — such as "How do I print sideways?" — the Assistant provides the information.

• Tips

  Based on the way you work with Office, the Assistant can give tips for methods that are more efficient, or show features you may not have discovered.

• Intelligent Help

  Based on your actions, the Assistant anticipates what you might need assistance with before you ask.

The Assistant is designed to help you work with the existing user interface — not to replace it. It is highly customizable, allowing you to control both its appearance and its behavior. There is an object model so that developers creating custom solutions with Microsoft Office can add their own Help to the Assistant.

For More Information   about creating custom solutions in Office, see the Microsoft Office 97/Visual Basic Programmer's Guide, published by Microsoft Press® and available wherever computer books are sold. For more information about Microsoft Press, see Appendix E, "Other Support Resources."

Office Art

All of the Office applications now use Office Art, one set of enhanced drawing tools. Using Office Art, you can create three­dimensional objects with shading, formatted fills, or textures that can also be used to enhance charts, Bezier curves, and connectors to create flow charts or diagrams. Special effects include lighting and finishes such as matte or metallic, and there are predefined shapes that you can size to your needs.

Text can be added to any object without creating an additional text box, and any drawing object can have a hyperlink associated with it. This makes it easy for any Office user to create effective navigation buttons or maps within documents or elsewhere.

Toolbars

Toolbars are now implemented as one piece of software across all of the Office applications. This feature is installed only once so it takes up less space on your hard disk, and less random access memory (RAM) when more than one application is in use. In addition, toolbars are now more flexible, allowing you to mix both buttons and menu items on the same toolbar. With more people creating and reading documents online, this flexibility allows you to get the menus and buttons that you use the most on one toolbar, giving you more space for your document.

Office Binder (Windows only)

Improvements have been made to Office Binder for Office 97. It is now possible to print these various file types with consistent headers and footers, including page numbering. In addition, there is now an integrated print preview for the entire binder.

Finally, binders are a great place to work on projects as a group. When an Office binder is used in conjunction with the Windows 95 or Windows NT Workstation 4.0 Briefcase application, the binder is replicated by section. Each user can place a copy of the binder in his or her Briefcase. When the file is updated, only the section that that user was working on is replaced; and the binder is updated with changes to other sections worked on by other users.

The Office 98 Value Pack for the Macintosh includes an unbind utility that enables users to break the Binder file into its individual Word, Excel, and Microsoft PowerPoint files. You must install the unbind utility from the Office 98 Value Pack.

Intelligent Applications in Microsoft Access 97

Database Wizard

Whether you are a novice or an experienced developer, the Database Wizard gets you started quickly. Choose from a list of over 20 types of databases, make some choices about the way you want your database to look, and click Finish. The Database Wizard builds a full­featured database and customizes it to your requirements. From there, you can add new elements to your database using the many other time­saving wizards found in Access 97.

Import/Export Wizards

You may often need to use data in many different formats. Access 97 offers three import/export wizards to help make the process of moving text, spreadsheet, and HTML data easy. When you use the Import command (File menu, Get External Data submenu) to import data, choose Text Files, Microsoft Excel, or HTML Documents in the Files of type box; the appropriate wizard takes you step by step through the process. The wizard even gives you a preview of how your data will look in the new format based on the choices you make.

Table Analyzer Wizard

The Table Analyzer Wizard can intelligently identify relationships in unstructured data and recommend the best way to organize that data in a relational database. This helps eliminate the problems associated with flat­file databases, where all information is combined into one table.

Simple Query Wizard

Regardless of the underlying structure of your database, the Simple Query Wizard can intelligently figure out how to bring information together to answer your questions. In the background, the Wizard automatically includes all the tables necessary to bring the desired data together. This process of background joining is found in the Form and Report Wizards as well. The result is that you worry less about how the data is stored, and can focus more on asking the questions.

Filter By Selection and Filter By Form

Often you know only a piece of the information you are trying to find. Filter By Selection allows you to highlight what you are looking for, and then limits your view of the data to only the items that match your selection. Filter By Form lets you use your familiar forms to find data in the same manner. Select an item from the drop­down list generated for a field, and Access 97 shows you the records that match your criteria.

Improved Form and Report Wizards

Based on the data on which you want to build a form or report, the Form and Report Wizards now change their behavior to give you appropriate choices for creating forms or reports. For example, if you choose to see information about customers and their orders, the wizard can build a form/subform or grouped report that displays the customer information once and lists the related orders on the same page.

Intelligent Applications in Microsoft Excel

Excel builds on a long history of simplifying data entry, formatting, and analysis tools. Some of the enhancements in Excel are described in this following section.

Natural Language Formulas

Creating formulas using archaic cell references (such as A1+B2) can be difficult for novice users and can make it hard to track down errors. In Excel, you can use your own terminology — your row and column headings — to create formulas, instead of using cell references.

For example, in the following illustration the formula to find March profit is derived by subtracting March Expenses from March Sales. The value of March Expenses is at the intersection of the column labeled March and the row labeled Expenses.

Formula AutoCorrect

Excel now fixes 15 of the most common mistakes users make when entering formulas. These mistakes are due to common typographical errors, as well as the use of syntax that is different from what Excel expects. For example, Excel can correct transposed cell references, change the semicolon (;) in a range reference to a colon (:), or add a closing parenthesis to a function's arguments. In the illustration below, Excel has corrected the common error of starting a formula with two equal signs.

Range Finder

Range Finder makes it easy to trace, modify, and understand which figures make up a formula. When you double­click any cell that contains an equation, each part of the equation is highlighted with its own color so you can see the pieces of your formula at a glance. This feature is implemented throughout Excel, including in charts. For example, if you click a data series on a bar chart, the range in your original data is highlighted. Range Finder also allows you to use drag and drop to modify your formula or chart range.

In the following illustration, the cells that are referenced in the PMT formula are color­coded for easy identification.

Merged Cells

Many users want to add rich formatting to their spreadsheets or forms, but are limited by the gridline layout of a spreadsheet. Excel breaks the grid limitation by allowing you to merge multiple cells together to create blocks of large cells, to rotate text to any angle within a cell, and to indent text within a cell. These options are available on the Alignment tab in the Cells (Windows) or Format Cells (Macintosh) dialog box (Format menu).

Updated Charting

The new Chart Wizard makes it easier to get the chart you want the first time by consolidating all the charting tools in one place. There are new chart types (such as pie­of­pie, conical, or bubble charts) and more formatting options (such as shaded or transparent fills) to help make your numbers look more professional. Formatting charts becomes easier as chart tips identify each portion of your graph before you change it, and display the actual value behind each data series.

Visual Printing

Ninety­five percent of Excel users print their spreadsheets, and almost all of them have experienced trouble defining exactly which part of their spreadsheet to print. To provide a more intuitive way to set the print area, Excel includes the Page Break Preview command (View menu). Each page displays a watermark showing what information will print on that page. Drag the page break to where you want it, and Excel automatically alters the column sizes, row sizes, or font sizes to make it all fit.

Multiple Undo

Conditional Formatting

Many users keep large spreadsheets to help track results. For example, it is common to see a spreadsheet displaying a log of sales results, by quarter and then by region, or a large sheet tracking inventory changes. Many users have indicated they would like to be able to track results in a large spreadsheet at a glance, without having to analyze each cell. The Conditional Formatting command (Format menu) allows you to apply automatic formatting rules to your spreadsheet — such as color, texture, or pattern — to help you find data you are looking for. For example, under­performing regions might be automatically flagged with a red background, and over­performing regions might be automatically flagged with a green background, so you can analyze a large spreadsheet at a glance.

Intelligent Applications in Microsoft Outlook 97

• Electronic mail (e­mail).

• Personal calendar and group scheduling.

• Personal information, such as contacts and tasks.

• Browsing and sharing documents.

• Custom groupware or information­sharing applications.

Outlook Bar

The Outlook Bar is the navigation headquarters for Outlook, housing special shortcuts that allow you to move effortlessly around the product. Using the Outlook Bar, it is easy to switch to:

• Outlook folders (Inbox, Calendar, Tasks, and so forth).

• E­mail folders.

• File folders or network drives.

• Microsoft Exchange public folders.

The Outlook Bar shown in the following illustration comes configured with all of the standard navigation choices; however, you can easily customize this bar to create a personalized desktop organizer.

AutoPreview

If you receive numerous e­mail messages in a day, AutoPreview can significantly reduce the time you spend reading these messages. AutoPreview displays the first few lines of the body of each message, so you can quickly process messages without opening them.

AutoNameCheck

AutoNameCheck helps ensure that your e­mail is sent to the intended recipients by quickly and clearly identifying ambiguous e­mail names.

When you compose a message, the Outlook desktop information manager automatically checks the e­mail names. If a name uniquely matches an entry in an address book, Outlook displays the full resolved name. If a name matches more than one address book entry, Outlook marks the ambiguous name with a red underline, similar to a misspelling in Word. You right­click an ambiguous name to choose the correct name from a list of matches. Outlook automatically remembers the ambiguous name as a nickname and proposes the same address book entry the next time you use the nickname.

Finally, Outlook automatically resolves and properly formats Internet e­mail addresses. Outlook removes spaces and changes commas to periods; for example, kylie hansen @ msn,com is resolved as kyliehansen@msn.com.

WordMail

You can use Word as the text editor for your e­mail messages. WordMail seamlessly integrates the familiar editing features of Word with the e­mail functionality of Outlook. Word features such as spelling and grammar checking, AutoText, styles, and templates work with the Outlook features such as AutoNameCheck, digital signatures, message tracking, and message flags.

Message Flags

Message flags are tags and dates you add to messages to remind yourself or a recipient that a message requires a follow­up action. You can flag messages after you receive them or before you send them.

If you work with your Inbox as a to­do list, you can flag specific messages with an action and due date. Actions can include Follow up, Respond, or your own text. Outlook reminds you when flagged messages are overdue and highlights overdue messages with red text. Flagged messages also display a flag icon in the view.

You can flag messages as you send them to indicate to recipients that a response is expected. Recipients see flagged messages with a small flag icon in the Inbox, and when they open the message, they see the text and due date for a response across the top of the message in the InfoBar.

Message Recall

If you inadvertently send a message before you mean to, you can attempt to recall the message from the recipients. Message Recall can either delete or replace the original message. Message Recall works across servers and across the Internet, but it recalls the message only if the recipient has not read it or moved it, and if the recipient is also running Outlook.

Views and View Switching

One of the design innovations introduced with Outlook allows you to quickly and easily adjust the way you look at the information on your screen. A view displays information using preset options for fields, grouping, filtering, and sorting. Each folder has a default view and a set of alternative views. Views do more than just display information — they help you see which information is important, and how information is related.

AutoName and AutoAddress

The full name you enter into a single field is automatically separated into first, middle, and last names. For instance, Outlook knows that Peter Michael Wilson, Jr.'s last name is Wilson, not Jr. If you have ever had to fill in a large database with names, you know how long it takes to separate out the elements of the name into appropriate fields. With the Outlook AutoName feature, this is done automatically. Addresses are handled in a similar manner by AutoAddress.

Journal

The Journal is a new component of personal information management software and is unique to Outlook. The Journal was created to help you keep track of information on your personal computer. This can include e­mail messages, documents you have been working on, an Excel spreadsheet someone sent you, or a phone call you made through Outlook.

Any communication or business entry can be recorded in the Journal. You no longer have to remember where a document is located, or under which file you stored a contact's e­mail message. With the Outlook Journal, all you have to remember is when the event occurred. Once you find the entry in the Journal, double­clicking that item opens it. The following illustration shows the Outlook Journal in timeline view.

AutoCreate

Software users in all walks of life are continuously burdened by the problem of data entry — there is always some information that needs to be retyped or recopied. With the Outlook AutoCreate feature, it is easy for information to be converted from one format to another without retyping. For example, you can change an e­mail message requesting a meeting into an appointment by dragging the message. Similarly, you can turn an appointment into a task by dragging the meeting from the calendar to the TaskPad. In every case, Outlook also inserts a shortcut in the newly created item, allowing you to move back to the original data.

Intelligent Applications in Microsoft Outlook Express

The easy setup, migration tools, and intuitive user interface of Outlook Express make performing everyday tasks such as sending, creating, and reading e­mail simple — especially for users who are new to the Internet or who are switching from another mail application.

Drag and Drop Support

Users can drag and drop messages, address book entries, and text in an easy and familiar manner. Drag­and­drop support helps users to organize their Inbox quickly by just dragging a message to a folder.

Migration Tools

In addition to a simple installation process, which makes it easy for users to set up multiple Internet e­mail and news accounts, Outlook Express includes migration tools. These tools allow users to import e-mail messages and address books from Eudora Pro, Eudora Light, Netscape Communicator, and Netscape Navigator.

Integration with Microsoft Internet Explorer

Outlook Express can be used alone or with Microsoft Internet Explorer. The Outlook Express user interface is consistent with that of Microsoft Internet Explorer, and is also readily accessible from Microsoft Internet Explorer.

Outlook Express User Interface

The Folder List is the navigation center for Outlook Express, allowing users to move effortlessly around the product. This feature gives users single-click access to folders, including the Inbox, Outbox, Sent Mail, Deleted Messages, and Drafts. The Folder List also gives users access to contacts, news servers, directory services, and mail servers. It comes configured with all of the standard navigation choices; however, users can easily customize the contents.

Users can also:

• Create multiple hierarchical folders to organize their e-mail.

  Folders are accessible from the Outlook Express Folder List.

• View the contents of e-mail messages in the preview pane.

  This feature helps identify which messages need an immediate response.

Intelligent Applications in PowerPoint

PowerPoint makes it quicker and easier than ever to create effective, professional­looking presentations. Enhancements to PowerPoint allow you to create presentations quickly and to customize them easily for sharing with your workgroup.

Enhanced AutoContent Wizard

The AutoContent Wizard makes it easy for occasional users to get up and running as quickly as possible by providing predefined formatting and content based on a series of simple questions. In PowerPoint, the AutoContent Wizard includes 30 new content templates, including templates for creating online or kiosk presentations.

Slide Finder

When you click Slides from Files (Insert menu), you can use the Slide Finder to integrate slides from existing presentations into your presentation. Slide Finder allows you to preview and insert only the slides you want from an existing presentation, without having to load the presentation or copy and paste the slides. Best of all, you can add presentations to the Favorites list for immediate access and updating.

Custom Shows

You can use the Custom Shows command (Slide Show menu) to reuse slides from existing presentations. Many users create multiple versions of a presentation, modifying only a few slides in each version to suit specific audiences. For example, a sales representative might give slightly different versions of the same presentation for two different customers.

The Custom Shows feature allows you to define, save, and print multiple versions of the same presentation in a single presentation file. Not only is it easier to organize these slides, but you save disk space because only one copy of each slide is maintained on your hard disk. When it is time to show your presentation, select the version of the show you want to use.

Expand and Summary Slide

If you are using PowerPoint 97 (Windows) and have too much content to be easily read on one slide, you can use the new Expand Slide command (Tools menu) to automatically distribute the information across several slides, based on the bullets on the original slide.

Animated Templates

PowerPoint includes a number of professionally created presentation designs that include animation effects, making it easy to create presentations that get your audience's attention. These animation effects are stored on the slide master and are automatically added every time you add a new slide to the presentation.

New Animation Settings

The new Custom Animation dialog box (Slide Show menu) provides one place for animating all the objects on a slide, including chart elements. You can easily modify animation effects, rearrange the animation order, and define timing settings for each object.

File Size and Loading Improvements

With the new architecture of PowerPoint, you can start working on presentations almost immediately after opening them, and saving files is nearly instantaneous. Built­in support for playing movies allows immediate playback of videos. In addition, file size is smaller because of built­in graphic and sound compression and the option to compress and decompress files on the fly.

Background Spelling Checker

PowerPoint now has background spell­checking that reviews your presentation for errors while you are working, and underlines incorrectly spelled words with a red wavy line. Right­click to see suggestions for the correct spelling of the word, or to select the option to ignore or add the word to your custom dictionary.

Intelligent Applications in Word

Word includes several enhancements to make content simpler to produce, more consistent, and better looking.

Letter Wizard

The Assistant in Word 97 and 98 works together with the Letter Wizard to offer assistance in creating letters. As soon as the Assistant sees that you are addressing a letter, it offers assistance and starts up the Letter Wizard. The Letter Wizard functions as a central place to choose and edit all letter elements. In addition, the Letter Wizard helps place all the necessary elements with the right punctuation. When you are done with your letter, it offers to guide you through the process of addressing an envelope.

You can use the Letter Wizard by double­clicking the Letter Wizard template on the Letters & Faxes tab in the New dialog box (File menu), or you can start typing a letter that begins with a salutation such as Dear or To. Word detects that you are writing a letter, and displays the Assistant.

AutoSummary

Different audiences for your documents often want to see varying levels of detail. Your manager may want all of the details of the project you are working on, but the division vice president may want only a synopsis. Through the AutoSummarize command (Tools menu), Word 97 and 98 help you automate document summaries by creating them for you. Word analyzes the document statistically and linguistically to generate summaries based on the following choices:

• Choose a percentage of the document or a word­count­based summary

• Condense the document or highlight relevant portions on-screen

• Create an abstract and insert it in the document

Background Grammar Checker

While you work, Word checks your document and puts a red wavy line underneath misspelled words. Right­click the word to see the suggested corrections.

Background grammar checking is similar to the spelling checker feature in Word. While you work, Word uses a new natural language grammar checker to scan your document for grammatical errors. It puts a green wavy line under problem words, phrases, or sentences; and when you right­click the underlined text, it suggests corrections, as shown in the following illustration.

By changing the options for the grammar checker on the Spelling & Grammar tab in the Options (Windows) or Preferences (Macintosh) dialog box (Tools menu), you control what mistakes it looks for.

Table Drawing Tool

Today, it is often easier to find information on the Internet than to find it within most organizations. Many organizations have their non­database information in Office file formats, and they would like to bring the easy navigation and searching capabilities of the World Wide Web to their internal networks (or intranets).

For More Information   about Office support for intranets, see Chapter 24, "Integrating Microsoft Office With Your Intranet."

Intranet and Workgroup Solutions in Office

Office combines the best of the Web with the best desktop productivity tools to provide an easy way for you to create, edit, and analyze information for effective communication. Office also includes features that allow users in a workgroup to work more effectively on projects, and to use Office as a development platform for quick and cost­effective custom solutions.

Hyperlinks

One of the best things about the Web is the ability to create and use hyperlinks. With one click, you can go to another subject. Hyperlinks have now been implemented in all of the Office document types.

Imagine a Word 97 or 98 document containing a proposal for a new division. It might contain a high­level overview of the budget needed for starting the division and a hyperlink to the Excel 97 or 98 spreadsheet that contains all the details. There could be hyperlinks to related projects, presentations to decision makers, research data, or even start­up calendar plans. Hyperlinks within Office documents are critical for a planned intranet, and they are also easy to create, which encourages the ad hoc information sharing that benefits any organization.

Web Toolbar

Word, Excel, Access, and PowerPoint have the same Web toolbar to make it easy to navigate to and use Office 97 and 98 documents online. The navigation buttons are the same as those in Microsoft Internet Explorer, and the Office applications use the same list as Microsoft Internet Explorer to track History and Favorites. Wherever you are on your desktop, you can get back to the information you were looking at most recently, regardless of its format.

Web Find Fast

Office first delivered Find Fast full­text searching and indexing in Office 95; this version of Find Fast ran on your hard disk. With Office 97, it is now possible to use Find Fast full­text searching and indexing on both traditional network servers as well as Web servers, indexing HTML files as well as Word, Excel, and PowerPoint files. In addition, administrator tools help you set up a search page, create a catalog of all documents, and configure what servers the search should be done on, thereby controlling the network traffic that could be generated.

Not only can Web Find Fast do full­text searching and indexing, it can also search by properties, both standard and custom, that are saved with each Office file such as Title, Author, Create Date, and so forth. This can significantly speed searching performance and dramatically reduce the network bandwidth required for an extensive search.

For More Information   about Web Find Fast, see Chapter 26, "Finding Microsoft Office Documents on the Network."

Viewers

Free viewers are available for Word 97 (Windows), Excel 97 (Windows), and PowerPoint 97 and 98 (Windows and Macintosh). These viewers allow users who do not have the application to view and print Office 97 or 98 documents.

For example, you can use the PowerPoint 97-98 viewer for the Macintosh to run slide shows on computers that do not have PowerPoint installed. The PowerPoint Viewer will be available for downloading from the Office Free Stuff Web site after June 1998. If you have access to the Web, you can connect to the Office Free Stuff site by clicking Help on the Web (Help menu), and then clicking Free Stuff. You can freely distribute Word, Excel, and PowerPoint viewers.

http://www.microsoft.com/office/

Browser Integration in Office 97 (Windows only)

In the following illustration, an Excel 97 file is open within Microsoft Internet Explorer 3.0, which is the initial application running. Most Excel and Microsoft Internet Explorer commands and toolbars are available.

Browser Integration in Office 98 (Macintosh only)

On a Macintosh, the Back button in the browser functions differently than on a computer running Windows. For example, when users click a hyperlink in a Word 97 or 98 document, the document appears in a new window. When Word 97 (Windows) users click the Back button, they are returned to the Word 97 application. When Word 98 (Macintosh) users click the Back button, they see the previous Web page displayed in the browser, instead of returning to Word 98.

Microsoft FrontPage Support and Integration

Microsoft FrontPage® gives authors the ability to create Web sites and the tools to manage those Web sites. With a graphical view of the structure of your Web site, you can see and edit any of the hyperlinks.

http://www.microsoft.com/frontpage/

IntelliMouse

Custom Solutions

Office 97 and 98 provide a complete development environment so you can create custom solutions for your intranet quickly, with very little cost. This environment includes the features described in the following sections.

Exposed Functionality

Each Office application has a complete and consistent object model, providing over 600 objects for use in custom development. You gain the benefit of years of developing, testing, and debugging built into Office. With this head start, you can quickly create custom solutions using objects from one or more Office applications to solve your business needs.

Visual Basic for Applications

Built on Visual Basic®, the Visual Basic for Applications programming language and the integrated development environment (IDE) built for it, are now included in Excel, Word, Access, and PowerPoint. Visual Basic is one of the most popular graphical user interface (GUI) programming tools available, with many developers well­versed in its use. The new IDE is also shared among the Office 97 and 98 applications, and comes complete with IntelliSense technology that makes programming easier.

Data Access Technologies

Office 97 can serve as the universal client for your desktop computers. With access to legacy and client/server databases through Microsoft Open Database Connectivity (ODBC) databases through Data Access Objects (DAO); to Internet data through support for HTML (Hypertext Markup Language), HTTP (Hypertext Transfer Protocol), and FTP (File Transfer Protocol); and to messaging data through MAPI, it no longer matters where your data resides. You can use the familiar desktop productivity applications to analyze your data.

On the Macintosh, data access differs in the following ways.

• Instead of data access objects, Excel 98 (Macintosh) supports XLODBC. In addition, whereas data access objects are supported in all the Office 97 (Windows) applications, only Excel 98 (Macintosh) supports XLODBC.

• Office 98 (Macintosh) documents cannot be saved to FTP servers.

• The only Office 98 (Macintosh) application that can be opened from an HTTP or FTP server is Word 98.

For More Information   about creating custom programming solutions with Office 97, see the Microsoft Office 97/Visual Basic Programmer's Guide, published by Microsoft Press and available wherever computer books are sold. For more information about Microsoft Press books, see Appendix E, "Other Support Resources."

Intranet and Workgroup Solutions in Microsoft Access 97

For More Information   about intranet support in Access, see "Web Support in Microsoft Access 97" in Chapter 25, "Web Support in Microsoft Office Applications."

Publish to the Web Wizard

Access 97 introduces several new features that allow you to share your database information with others over an intranet or the Internet. HTML is a new report output format so you can quickly save your database reports to a Web site. If you prefer to give people a live view of your data, you can use the Publish to the Web Wizard to quickly set up interactive database pages that let Web browsers query, update, or add information. The following illustration shows the wizard.

Database Splitter Wizard

The value of a database lies in its ability to have many people working with the same data at the same time. The Database Splitter Wizard in Access 97 helps you set up your database so that many people can use it over a network while preserving the best performance. Shared data tables are separated from the rest of the database, which is posted on a file server. Links are then set up to the tables in the new shared file.

Performance Analyzer Wizard

The Performance Analyzer Wizard found in Access 97 helps you make your existing database perform more efficiently. The Wizard looks at your database and returns recommendations about how to make it faster. Best of all, the Performance Analyzer Wizard can often make those suggested changes for you.

Improved Integrated Development Environment

Access 97 uses the programming language Visual Basic, which is shared across all the Office applications. Because Access 97 is also an Automation object, Visual Basic can be used both inside and outside Access to automate database functions. The IDE in Access 97 offers drag­and­drop code, color formatting, an improved debug window, and a new hierarchical object browser.

Programmable Toolbars

Access 97 allows solution builders to fully control the user interface of their applications using Visual Basic. Custom toolbars can be created and controlled using the new object model that is shared across Office 97.

Internet Replication

Using Database Replication in Access 97, you can now synchronize data from multiple locations using the Internet as your wide­area network (WAN). For example, remote sales people can replicate updates to customer information back to headquarters using an Internet connection from anywhere in the world.

Note   Synchronization over the Internet requires the Replication Manager, which is available in Office 97 Developer's Edition.

http://www.microsoft.com/officedev/

Removing Source Code

Developers can now remove their source code from the databases they distribute to others, thereby reducing the size of the database and protecting their intellectual property. To remove source code from a database, save a copy of your database as an MDE file.

Web Controls

Access 97 includes ActiveX™ controls designed specifically for people developing Web applications. After you install Microsoft Internet Explorer 3.0, you can place the WebBrowser control on Access forms. The version of Access included in Office 97 Developer's Edition includes ActiveX controls that support HTTP, FTP, Gopher, and Winsock functionality.

Intranet and Workgroup Solutions in Microsoft Excel

For More Information   about intranet support in Excel, see "Web Support in Microsoft Excel" in Chapter 25, "Web Support in Microsoft Office Applications."

Importing from HTML

Web Queries

Although importing from HTML works well with HTML data you encounter when browsing, you might also want to import changing Internet or intranet data regularly into an existing document. For example, you could create a spreadsheet and chart to display your stock portfolio, or a chart that tracks census data. Web queries allow you to set up an automatic hyperlink that brings this HTML data into your spreadsheet from the Web. Once the data is in Excel, you can use its powerful analysis tools to analyze the data.

Saving as HTML

With the Internet Assistant Wizard for Excel 97 (Windows) and Excel 98 (Macintosh), you can post spreadsheet data for online viewing. This wizard assists in converting spreadsheet data to HTML, either as a separate document or into an existing HTML document. In Excel, this feature has been enhanced to transform charts into a GIF file.

Using the Save as HTML command (File menu), you can convert Excel spreadsheet data and charts into HTML. If spreadsheet information contains Office hyperlinks (inserted using the Hyperlink command on the Insert menu), they are automatically converted into HTML hyperlinks.

The Save as HTML command allows you to convert all tables and lists into a Web document for the Internet or an intranet, without having to understand the code associated with HTML.

Multiuser Workbooks with Data Tracking

Increasingly, more people are working as teams on projects and sharing information to get their work done. Multiuser workbooks now allow multiple users to work on the same workbook and track changes to that document at the same time. The worksheet can now update changes automatically, and can even track revisions by user in each cell. In addition (similar to Word), you can document your worksheets by leaving comments on the screen for other users.

PivotTable Improvements

PivotTables® have become an essential analysis and presentation tool for many Excel users. The enhancements to PivotTables in Excel 97 and 98 are described in this section.

New PivotTable Wizard

The PivotTable Wizard has been redesigned to make it easier for users of all levels to create dynamic views of their data. It is integrated with the Assistant to give better support to new users, and some of the screens have been redesigned to make them easier to use, while allowing more options from within the wizard.

Persistent Formatting in PivotTable Dynamic Views

The biggest frustration for PivotTable users is that their formatting is erased when they pivot or refresh their data. In Excel 97 (Windows) and Excel 98 (Macintosh), however, formatting is linked to elements of the worksheet — so it is preserved if you refresh or pivot the table, and it stays with the data it is intended to highlight.

Updated Data Access

Excel 97 and Excel 98 include the following enhancements to queries.

Distributable Queries

Distributable queries were designed to solve the problem of distributing predefined queries and reports to users in a corporate environment. Users run the queries when they need them and then complete their analysis in Excel.

Parameterized Queries

Parameterized queries are similar to the distributable queries, but parameterized queries also allow per­user customization. For example, one user could choose to see sales for North America, while another might be interested in worldwide sales. By allowing users to define their own parameters within a query, you do not have to design separate reports.

Asynchronous Queries

All queries now execute on a separate thread. This feature allows you to work on your spreadsheet while a query runs in the background.

Support for URLs

Intranet and Workgroup Solutions in Microsoft Outlook 97

For More Information   about intranet support in Outlook, see "Web Support in Microsoft Outlook 97" in Chapter 25, "Web Support in Microsoft Office Applications."

Electronic Mail

The simplest workgroup activity that co­workers engage in is e­mail. It's quick, efficient, can be done at any time, and you do not have to play phone tag. For many organizations, it is now the primary means of communication. The best e­mail client for Office 97 users is Outlook. It works like all the other Office applications and has specific integration to make communicating easier.

Outlook IntelliSense features make it easy to communicate within your workgroup. AutoPreview, which shows the first three lines of each message, helps you keep your Inbox under control. The Message Flag feature allows you to add a reminder to an e­mail item to make sure you remember to follow up on it. Use the voting feature to quickly find out what module of a training course your workgroup would like to observe. You can use rich text editing or use Word as your e­mail editor to make your messages more effective.

Outlook works with many back­end mail systems, including Microsoft Mail 3.x, Exchange Server, POP3, and SMTP.

AutoVoting

When you want others to answer a question, you can use the Outlook voting feature to collect their responses in e­mail. For example, before submitting a bid to a customer, use voting to ensure that the entire team has signed off on it. Outlook automatically tallies the votes as they arrive, so users can look at their copy of the sent message to see the results.

Outlook Forms

Forms Design functionality in Outlook allows you to extend your groupware applications or to customize any of the built­in forms. Outlook includes small, interpretive forms that look and function like many standard paper­based forms. These can be quickly configured, allowing you to switch easily between design and run time. In addition, Outlook also includes a number of preconfigured forms, including the following:

• Expense Reporting

  This form uses Excel templates for collecting and reporting employee expenses.

• Vacation and Sick Leave

  These e­mail­based forms synchronize with your calendar for vacation and sick­leave reporting.

• While You Where Out

  Any user can take a message for another employee using a form modeled on the standard pink paper While You Where Out form — and then send the message to the employee's Inbox.

• Timecard

  This e­mail­based form synchronizes with the Outlook Calendar and Journal for timecard reporting.

• Web Site

  This form uses Microsoft Internet Explorer as an ActiveX control and contains a number of fields to categorize information about commonly used Web sites.

Group Scheduling

Another common group activity is scheduling meetings. Building on its Schedule+ heritage, Outlook makes it easier for a group of people to find the right time to meet. The Meeting Planner helps you pick required and optional attendees, as well as a conference room or other resources such as audio/visual equipment. AutoPick automatically picks the next available time for all required attendees and resources.

Task Requests and Tracking

Outlook makes it easy for users to send task requests to one another, and for managers to assign tasks to team members. Outlook also automatically tracks the status of task requests and sends updates to the requester. You create task requests in your own task list, and then send them to other users. As the recipient accepts the task, Outlook adds a copy to the recipient's task list. As the recipient updates the task with completion status, Outlook automatically sends an update message back to you and updates your copy of the task.

Outlook task requests are integrated with Microsoft Project and Microsoft Team Manager, allowing users of those products to delegate tasks to Outlook users.

Intranet and Workgroup Solutions in Microsoft Outlook Express

• Broad support of many Internet standards, including:
  • Simple mail transfer protocol (SMTP)

  • Post office protocol 3 (POP3)

  • Internet mail access protocol (IMAP4)

  • Lightweight directory access protocol (LDAP)

  • HTML

  • MIME HTML (MHTML)

  • Network news transfer protocol (NNTP)

• Support for offline work and mobile tasks

• Multiple account support

• Support for multiple e-mail and news server accounts

• Additional functionality in the address book

Outlook Express offers users the features and support they want to communicate, manage, and find the information they need. The following table lists some of the new features available in Outlook Express.

Feature	Description
Support for Offline and mobile tasks	Outlook Express provides extensive support for offline and mobile users, which includes IMAP4 support, Inbox and newsgroup filters, and efficient connection management. IMAP4 support allows users to maintain e-mail on a server for easy access from different locations and desktops.
Multiple account support	Users who have more than one e-mail or newsgroup account can easily send and receive mail from all of their accounts with a single command in Outlook Express.
Support for multiple users	Separate Inboxes and address books allow more than one user to receive mail on the same computer.
Integrated e­mail and newsgroups	With Outlook Express, users can read and participate in e-mail and newsgroups seamlessly, without having to switch applications or windows.
HTML e­mail	Outlook Express brings the graphically rich characteristics of the Web to e-mail by allowing users to receive HTML messages. Users can even author basic HTML with Outlook Express.
AutoHyperlinks	Outlook Express automatically recognizes and creates hyperlinks from text. For example, when users type in a URL or file transfer protocol (FTP) site, the AutoHyperlink feature automatically creates a hyperlink.

With the Outlook Express address book, users can maintain extensive contact information, including multiple addresses and phone numbers. Users can also perform the tasks described in the following table.

Task	Description
Finding people on the Internet or intranet	Outlook Express can search the Internet or your intranet for a contact's address. Lightweight Directory Access Protocol (LDAP) server support lets users find people on the Internet or an intranet through directories such as 411 and Bigfoot, or your company's internal directory.
Resolving names	Outlook Express automatically identifies address book and intranet LDAP entries that match the entries typed in by a user. This feature helps users quickly select correct addresses.
Creating mailing lists	Users can easily group their contacts in the address book into mailing lists for sending the same message to many people.
Integrating the address book with Word 98	Outlook Express contains a contact-management module that can be integrated into the Mail Merge feature in Word 98. By clicking the Insert Address button in the Envelopes and Labels dialog box (Tools menu), Word users insert names and addresses from Outlook Express.

Intranet and Workgroup Solutions in PowerPoint

PowerPoint includes enhancements for publishing presentations on the Web. The new AutoContent Wizard includes templates designed for online documents. The ability to convert presentations to HTML is built in to PowerPoint, and the PowerPoint Animation Player works with your Web browser to play multimedia presentations in real time over the Web. The Presentation Conferencing feature in PowerPoint 97 (Windows), furthermore, allows you to deliver a live presentation over a network or over the Internet.

For More Information   about intranet support in PowerPoint, see "Web Support in Microsoft PowerPoint" in Chapter 25, "Web Support in Microsoft Office Applications."

Save as HTML Wizard

With the Save as HTML command (File menu) in PowerPoint, you can build dynamic presentations that can be easily exported as robust HTML pages without having to master HTML. The Save as HTML Wizard asks a series of simple questions:

• Would you like your output to contain frames?

• Would you like your speaker notes displayed as text?

• Would you like to include an outline that allows those viewing your presentation to browse through your slides manually?

• Would you like your presentation to have hyperlinks?

• Would you like your presentation to export as static GIF or JPEG images, or would you like it to export as a full animation?

You can leverage what you know already about PowerPoint to create a dynamic, effective Web page.

PowerPoint Animation Player

Those who want to view the animation can install the PowerPoint Animation Player (a browser extension that works with Netscape Navigator 2.0 or higher and with Microsoft Internet Explorer 3.0 or higher), which allows individuals to view a full­fidelity presentation within a window.

Presentation Conferencing

Presentation Conferencing allows users to join a conference over the network, and then transmits the presentation to all of those users. It is a live meeting; the presenter advances the slides and controls the presentation on all of the audience members' computers. Presentation Conferencing supports up to 64 users connected through TCP/IP on a LAN, WAN, or an Internet connection.

Intranet Solutions in Word

Word has a number of tools that allow easy publishing to the Web, such as converters for converting documents to and from HTML format. Word 97 (Windows) users save documents to an FTP site. The Word viewer allows users without Word 97 to view documents. Word 97 and 98 also provide strong support for viewing a document online and quickly moving between parts of a document.

For More Information   about saving documents to an FTP site, see "Opening and Saving Documents on the Internet" in Chapter 24, "Integrating Microsoft Office With Your Intranet." For more information about intranet support in Word, see "Web Support in Microsoft Word" in Chapter 25, "Web Support in Microsoft Office Applications."

AutoHyperlink

There are many new AutoCorrect improvements in Word, including AutoHyperlink, which automatically creates a hyperlink from text that appears to be a hyperlink. For example, Word can automatically format the address of a file, a network path, or an Internet address as a hyperlink: The text is formatted in blue with an underline and when the mouse pointer is over it, it turns into a hand to signify that it goes to the destination when clicked.

Document Map

The document map in Word allows you to move around in your document more easily. A split screen displays an outline of your document in the left pane, while the right pane contains the text of your document. Hyperlinks in the outline give you one­click access to points of interest, and serve as a roadmap by highlighting the level at which you are currently located, as shown in the following illustration.

To switch to the document map view, click the Document Map command (View menu).

Online Reading View

Word makes reading documents online more comfortable. In the past, fonts that were readable in print were not as easy to view online, and it was difficult to move around in long documents. Because the use of intranets will increase the frequency with which people read documents online, Word includes the Online Layout command (View menu) to make it easier.

In online reading view, the fonts are enlarged slightly and text does not wrap outside of the screen area, which eliminates the need to scroll from side to side. Finally, the Document Map feature is turned on in online reading view, which turns the left­hand section of the screen into an outline with hyperlinks to the full document text. None of these views affect how the document is printed.

Internet Assistant

Using the Internet Assistant for Word, you can use the familiar Word features to create Web documents. The Internet Assistant features are available whenever you create or open an HTML document. Word allows you to create sophisticated Web pages without having to learn HTML. Word supports the following HTML tags, which means you can create multimedia pages without having to learn a new program.

• New backgrounds

  Create visually appealing and compelling documents using new background colors and textures. Choose from two dozen built­in textures or create your own custom textures using Office Art.

• Bullets

  Use graphically rich bullets designed specifically for HTML documents.

• Horizontal lines or rules

  Using built­in borders and shading functionality, create colorful and graphical horizontal lines for HTML documents. A new Horizontal Lines dialog box (Insert menu) allows you to choose from a variety of colorful horizontal line images. For quick access to the last selected line style, click the Horizontal Line command (Insert menu) when an HTML document is active.

• Pictures

  Insert pictures in a Web page using the same Picture command (Insert menu) that you use with a standard Word document. Word automatically converts and compresses graphics and OLE objects to JPEG or GIF images. Word also allows graphics to be hyperlinks.

• Video

  Choose the video clip to play, and define when it plays and how often it plays.

• Sound

  Using the background sound control in Word, specify a sound file and the number of times to play it.

• Marquee text

  Create a banner of text that scrolls across your screen. You have control over the animation, direction, speed, background color, and size of text.

• Blinking text

  Apply this popular animation effect to any text in your Web page, just like you can in a standard Word document.

• HTML forms

  Use the same approach to forms design regardless of whether you are creating forms in a standard Word document or an HTML document. Word provides the following form types and buttons:

  • Check box

  • Password control

  • Radio button

  • Text box

  • List box

  • Select drop down

  • Select text area

  • Control submit button

  • Image submit button

  • Reset button

Version Control

The options in the Versions dialog box (File menu) allow you to save different versions of the same document in the same file. This feature avoids the extra work and space required for tracking versions in separate files. A version is saved whenever you choose to do so, or you can activate a setting that automatically saves a new version each time you close the file. Save your comments with the version to make it easy to go back to the version you need.

Address Book Integration