To view this information, run the Setup program again to install the application and its Help files.


Close the Office Shortcut Bar

1	On the Office Shortcut Bar, click [image] to open the Office menu.

2	Click Exit.


Move the Office Shortcut Bar

1	If the Office Shortcut Bar is minimized, click it on the Windows taskbar.

In Windows NT, double-click the minimized Office Shortcut Bar icon.

2	Drag the Office Shortcut Bar where you want it — either docked to one edge of your screen or floating on the desktop.

Note   When you dock the Office Shortcut Bar along an edge of your screen, Windows resizes your desktop so that the Office Shortcut Bar is outside the desktop and doesn't cover anything else.


Open a different toolbar on the Office Shortcut Bar

•	Click a toolbar to display it.

Tip   If the toolbar you want is not visible on the Office Shortcut Bar, use the right mouse button to click the background of any toolbar, and then click the name of the toolbar you want on the shortcut menu.


Change the appearance of the Office Shortcut Bar

1	Using the right mouse button, click the background of any toolbar on the Office Shortcut Bar, and then click Customize.

In the dialog box that appears, the View tab is selected by default.

2	Select or clear the check boxes you want.

Note   The Change Color button affects only the toolbar that appears in the Toolbar box. The check boxes affect all the toolbars on the Office Shortcut Bar.


Change my default Office settings

1	Using the right mouse button, click the background of any toolbar on the Office Shortcut Bar, and then click Customize.

2	Click the Settings tab, and then click the setting you want to change in the Item/Setting box.

3	Click Modify.

4	In the Setting box, specify a new setting.

To locate a folder, click Browse.


Restore the default Office Shortcut Bar

This procedure restores the default toolbars on the Office Shortcut Bar — for example, the Desktop, Office, Accessories, and Programs toolbars. This procedure doesn't remove your custom toolbars. For more information about removing toolbars from the Office Shortcut Bar, click  [image].

1	On the Office Shortcut Bar menu, click Add/Remove Office Programs to start the Office Setup program in Maintenance mode.

2	Click the Reinstall button, and then follow the prompts on the screen to reinstall the Office Shortcut Bar.


Hide the Office Shortcut Bar

•	To hide the Office Shortcut Bar, click Auto Hide on the Office Shortcut Bar menu. When the command has a check mark next to it, Auto Hide is on.

•	To use the Office Shortcut Bar when it's hidden, point to the edge of the screen where the Office Shortcut Bar is docked; the Office Shortcut Bar will appear. For example, if the Office Shortcut Bar is docked on the right side of your screen, just point to this side of the screen.


Move a toolbar button on the Office Shortcut Bar

•	While holding down ALT, drag the toolbar button to a new location on the same toolbar or to a different toolbar.


Managing a schedule from the Office Shortcut Bar

The Office toolbar provides three single-click shortcuts to the Microsoft Schedule+ features you'll probably use most often.

•	To add a new contact to your Schedule+ contact list, click  [image].

•	To insert a new appointment in your Schedule+ calendar, click  [image].

•	To create a new one-time task or recurring task in Schedule+, click  [image].


Rename a toolbar button on the Office Shortcut Bar

To rename a toolbar button, change the name of the shortcut, file, or folder in either My Computer or Windows Explorer.

Note   This method doesn't work for renaming toolbars.


Rename a toolbar on the Office Shortcut Bar

Changing the name of the toolbar folder doesn't change the name of the toolbar.

1	Create a new toolbar with the name you want.

   How?

2	While holding down ALT, drag each button from the old toolbar to the new toolbar.

3	If you no longer need the old toolbar, remove it.

   How?


Add a toolbar button for a file or folder to the Office Shortcut Bar

When you add a toolbar button for a file or folder to a toolbar, the Office Shortcut Bar creates a Windows shortcut to the file or folder. If you later delete the toolbar button, you delete the shortcut but not the original file.

1	Using the right mouse button, click the background of any toolbar on the Office Shortcut Bar, and then click Customize on the shortcut menu.

2	Click the Buttons tab.

3	In the Toolbar box, click the name of the toolbar to which you want to add a button.

4	In the Show These Files As Buttons box, click the button or space above which you want to add the new toolbar button.

5	To add a button for a file, click Add File.

To add a button for a folder, click Add Folder.

Tip   To quickly add a button to a toolbar, drag the file or folder from My Computer or Windows Explorer to the toolbar on the Office Shortcut Bar.


Delete a toolbar button from the Office Shortcut Bar

1	Using the right mouse button, click the background of any toolbar on the Office Shortcut Bar, and then click Customize on the shortcut menu.

2	Click the Buttons tab.

3	In the Toolbar box, click the name of the toolbar that contains the button you want to delete.

4	In the Show These Files As Buttons box, click the button you want to delete, and then click Delete.

5	Click OK.

6	If you're sure you want to permanently remove the item from both the toolbar and your hard disk, click Yes.

Tip   If you think you'll need the button again, hide it rather than remove it.


Hide or display a toolbar button on the Office Shortcut Bar

1	Using the right mouse button, click the background of any toolbar on the Office Shortcut Bar, and then click Customize on the shortcut menu.

2	Click the Buttons tab.

3	In the Toolbar box, click the name of the toolbar that contains the button you want to hide or display.

4	In the Show These Files As Buttons box, clear or select the check box next to the button you want to hide or display.

Tip   To quickly hide a button, use the right mouse button to click the toolbar button, and then click Hide Button.


Add a toolbar to or remove a toolbar from the Office Shortcut Bar

When you remove a toolbar from the Office Shortcut Bar, you delete that toolbar from the Toolbars box, but you don't delete the toolbar folder from your hard disk. If you think you'll need the toolbar again, hide it rather than remove it.

When you hide a toolbar, the toolbar doesn't appear on the Office Shortcut Bar, but it still appears in the Toolbars box, so you can display the hidden toolbar again when you want to use it.

What do you want to do?

Add a toolbar to the Office Shortcut Bar

Remove a toolbar from the Office Shortcut Bar

Hide or display a toolbar on the Office Shortcut Bar


Add a toolbar to the Office Shortcut Bar

1	Using the right mouse button, click the background of any toolbar on the Office Shortcut Bar, and then click Customize on the shortcut menu.

2	Click the Toolbars tab.

3	Click Add Toolbar.

4	To create a toolbar for an existing folder, click Make Toolbar For This Folder, and then type the path to the folder. To locate the folder, click Browse.

To create a new, blank toolbar, click Create A New Blank Toolbar Called, and then type a name for the new toolbar.


Remove a toolbar from the Office Shortcut Bar

1	Using the right mouse button, click the background of any toolbar on the Office Shortcut Bar, and then click Customize on the shortcut menu.

2	Click the Toolbars tab.

3	In the Show These Folders As Toolbars box, click the name of the toolbar you want to remove.

4	Click Remove.


Hide or display a toolbar on the Office Shortcut Bar

1	Using the right mouse button, click the background of any toolbar on the Office Shortcut Bar toolbar.

2	On the shortcut menu, click the name of the toolbar you want to hide or display.

When the toolbar name has a check mark next to it, the toolbar is visible on the Office Shortcut Bar. When the toolbar name has no check mark next to it, the toolbar is hidden.


Open a file from the Office Shortcut Bar

1	On the Office toolbar, click  [image].

2	Locate the document you want to open, and then double-click the name of the document.

Tip   To keep frequently used documents and folders together, click  [image].  To open a document or folder after you add it to the list in the Favorites box, click  [image].


Start a new file from the Office Shortcut Bar

1	On the Office toolbar, click  [image].

2	Click the tab for the type of document you want to create.

3	Click the template or wizard you want to base your document on.


Finding, opening, and managing documents


Getting assistance while you work


Combining and organizing related files


Taking a shortcut to work


Personal and business planning with Schedule+


What's new in Microsoft Office


WordArt, Equation Editor, and Graph

Word and PowerPoint include applications that help you add special text effects, equations, and charts to your documents. WordArt, Equation Editor, and Graph create objects that you insert, or embed, into a document. These applications all use OLE to share information between applications.

 If you selected the Typical setup option when you installed Word or PowerPoint, then you installed Graph. If you would also like to install WordArt and Equation Editor run Setup again. Click Add/Remove, and then select Office Tools. To verify that the applications were installed, click Object on the Insert menu. All of the installed applications are listed under Object Type.


Insert a Microsoft Access table or query as a Word table

1	In the Word document, click where you want to insert a Microsoft Access table or query.

2	On the Insert menu, click Database.

3	Under Data Source, click Get Data.

4	In the Files Of Type box, click MS Access Databases (*.mdb).

5	In the File Name box, enter the name of the Microsoft Access database you want, and then click OK.

6	Click Table AutoFormat or Query Options.

7	In the list, select the table or query you want, and then click OK.

8	Click Insert Data.

9	Under Insert Records, select the records you want to insert into your Word document.


Import a text file into Microsoft Access from Word

Microsoft Access can import delimited text files from Word. In a delimited text file, fields are separated by a special character, such as a comma or a tab. Before you import, make sure that the file has the same type of data in each field and the same fields in every row. In Word, save the file in the Text Only With Line Breaks file format.

1	In Microsoft Access, open a database, or switch to the Database window for the open database.

2	On the File menu, point to Get External Data, and then click Import.

3	In the Import dialog box, click Text Files in the Files of type list.

4	Use the Look In list to find the file you want to import.

5	Double-click the filename.

6	Follow the directions in the Import Text Wizard dialog boxes.

To see more options or change specifications, such as the field separator character, click Advance in the first wizard dialog box. If you want to save your specifications so that you can use them the next time you import a similar text file, click Save As.


Troubleshoot problems in Word with linked or embedded objects

What do you need help with?

When I attach a mail merge data file or insert a database, Word automatically starts the source application to get the data. How can I get the data without starting the source application?

Word restarts numbering after I insert a table or embedded object.

In Word, my embedded objects return to their original size after I resize them.

In Word, my large embedded objects are cropped.

When I use a Microsoft Access database in Word by means of ODBC, the Queries tab is not available.


When I attach a mail merge data file or insert a database, Word automatically starts the source application to get the data. How can I get the data without starting the source application?

When you insert a database or attach a data source for a mail merge, Word uses DDE to read the file unless you specify otherwise. DDE starts the source application, such as Microsoft Excel or Microsoft Access, and then opens the data file.

Instead of DDE, you can use ODBC or a file converter to read the data file directly, without starting the source application. To do this, in the Open Data Source dialog box that appears when you open the data file, click Select Import Method before you click Open. Then, each time you open a data source, Word opens the Confirm Data Source dialog box so that you can click the ODBC driver or file converter you want to use.


Word restarts numbering after I insert a table or embedded object.

If you insert a table or embedded object in a numbered list, Word restarts the numbering of the paragraph following the table or object at 1. Use one of the following methods to generate a continuously numbered list.

•	Insert a section break before or after the table or embedded object. Click the numbered item following the table or embedded object, click Bullets And Numbering on the Format menu, click the Numbering tab, and then click Modify. In the Start At box, replace 1 with the correct number in the numbering sequence.

•	Apply a heading style to your numbered paragraphs, and use the Heading Numbering command on the Format menu instead of the Bullets And Numbering command to number the paragraphs.

•	Instead of using the Bullets And Numbering command, use SEQ, AUTONUM, AUTONUMLGL, or AUTONUMOUT fields to number your paragraphs.


In Word, my embedded objects return to their original size after I resize them.

Word inserts an EMBED field in your document when you embed an object. If the EMBED field contains the \s switch, the object returns to its original size whenever you update the field. To keep the new size, remove the \s switch from the EMBED field. For example, modify the EMBED field for an embedded Excel Chart object

{EMBED Excel.Chart.5 \s}

so that it appears as follows:

{EMBED Excel.Chart.5}

Note   To view the field code instead of the embedded object, click the object and then press SHIFT+F9.


In Word, my large embedded objects are cropped.

When you link or embed a large object, it may be cropped from the right side or the bottom. This can occur even if there is enough room on the page for the entire object to fit.

Whether you link or embed an object, Word converts the object to a Windows metafile (WMF). Windows limits the height and width of a WMF, so if your selection exceeds the maximum WMF size, it will appear cropped when you paste it into Word.

To avoid having a large object cropped when you link or embed it, do one of the following.

•	Make the object smaller before you copy or cut it. For example, reduce the font size and the column size.

•	Paste or link the selection in Word as formatted or unformatted text. To do this, click Paste Special on the Edit menu, and then click Formatted Text (RTF) or Unformatted Text in the As box.


When I use a Microsoft Access database in Word by means of ODBC, the Queries tab is not available.

ODBC does not open Microsoft Access when you insert a database into Word; instead, it accesses the data file directly. You must have Microsoft Access open before you can perform a query. To use a Microsoft Access query as a data source for a mail merge or in a Word DATABASE field, you must open the file by using DDE, because DDE opens Microsoft Access to access the database. To use DDE instead of ODBC, click Database on the Insert menu, click Get Data, and then select the Select Import Method check box before you click Open. With Select Method selected, each time you open a data source, Word opens the Confirm Data Source dialog box so that you can click DDE or another conversion option.


Troubleshoot problems in PowerPoint with linked or embedded Word objects

What do you need help with?

PowerPoint limits the size of Word tables I can embed. How can I embed a larger Word table?

PowerPoint sometimes crops the borders on my embedded Word tables.

PowerPoint adds gridlines to some of my embedded Word tables.


PowerPoint limits the size of the Word table I can embed. How can I embed a larger Word table?
PowerPoint limits the size of Word tables I can embed. How can I embed a larger Word table?

There are several different ways to embed a Word table in PowerPoint, and each method has a different maximum number of table rows and columns.

•	If you create a slide that includes a Word table placeholder and you double-click the placeholder, PowerPoint prompts you to specify the number of rows and columns in your table. Using this method, you can create a table with up to 7 columns and 15 rows.

•	If you click the Word Table button on the Standard toolbar in PowerPoint, you can create a table with up to 15 columns and 5 rows.

•	To create a Word table in PowerPoint that contains a larger number of rows and columns, embed a new Word document object in your PowerPoint slide. In Word, use the commands on the Table menu to create the table you want.


PowerPoint sometimes crops the borders on my embedded Word tables.

An embedded Word object has default margins of 0 (zero) inches and a page size of 6 inches by 9 inches, or smaller. If the page width of the embedded Word object is greater than 6 inches, one side of the object may appear cropped.

To preserve margins and page sizes for an embedded Word object, insert a new Word object, and then paste the contents of the Word document into the open object. When you select the Word document, be sure to include the section breaks and final paragraph mark, which contain the page size and margin settings for the document.


PowerPoint adds gridlines to some of my embedded Word tables.

When you apply shading to a Word table, Word leaves thin spaces between the cells. When you paste the table into PowerPoint, these spaces pick up the background colors in PowerPoint and look like table gridlines.

To eliminate the lines, make the background of your slide the same color as the Word table.

1	In PowerPoint, use the Rectangle drawing tool to draw a rectangle that exactly covers the table.

2	On the Format menu, click Colors And Lines.

3	Change the fill color so that it matches the color of your Word table shading.

4	On the Draw menu, click Send To Back.


Creating a PowerPoint presentation from a Word outline

You can also create a PowerPoint presentation from a Word outline. In Word, click the Present It button on the Microsoft toolbar to create PowerPoint slides from the Word document. Each paragraph formatted with the Heading 1 style becomes a separate slide, and paragraphs formatted with Headings 2 style through Heading 5 style are indented. PowerPoint imports only those paragraphs formatted with a heading style.


Troubleshoot file importing problems between Microsoft Access and Microsoft Excel
Troubleshoot file-importing problems between Microsoft Access and Microsoft Excel

What do you need help with?

In Microsoft Excel, all of the time values in my imported Microsoft Access table appear as the date 1/0/00.

When I import a Microsoft Excel worksheet into a Microsoft Access database, the date fields are all off by four years.


In Microsoft Excel, all of the time values in my imported Microsoft Access table appear as the date 1/0/00.

Microsoft Excel and Microsoft Access interpret serial numbers differently. Microsoft Excel automatically formats all serial numbers in imported Microsoft Access tables as dates. Use the following procedure to change the format of imported serial numbers to a time format in Microsoft Excel:

1	Select the values whose format you want to change in the worksheet.

2	On the Format menu, click Cells, and then click the Number tab.

3	In the Category box, click Time. In the Type box, select the time format you want.


When I import a Microsoft Excel worksheet into a Microsoft Access database, the date fields are all off by four years.

The 1904 date system was used in the Microsoft Excel worksheet instead of the default 1900 date system used by both Microsoft Excel and Microsoft Access. To change your Microsoft Excel worksheet from the 1904 date system to the 1900 date system, follow these steps in Microsoft Excel before you import the worksheet into Microsoft Access:

1	Open the Microsoft Excel worksheet.

2	On the Tools menu, click Options, and then click the Calculation tab.

3	Clear the 1904 Date System check box.

Note   The 1900 date system starts numbering with 1, which represents January 1, 1900. The 1904 date system starts numbering with 0 (zero), which represents January 1, 1904.


Share information between Microsoft Excel and Microsoft Access

To import Microsoft Access data into Microsoft Excel, you must first convert the Microsoft Access file to Microsoft Excel format. The Analyze It With MS Excel button in Microsoft Access does this for you in a single step. This button saves the contents of a Microsoft Access datasheet, form, report, or module as a Microsoft Excel worksheet (.XLS) file and opens the file in Microsoft Excel.

No conversion is required to import a Microsoft Excel worksheet into Microsoft Access. When you import a Microsoft Excel worksheet, Microsoft Access creates a new table to store the imported data. If the Microsoft Excel worksheet contains field names in the first row, Microsoft Access can use these as field names in the new table.

What do you want to do?

Import Microsoft Access data into Microsoft Excel

Import Microsoft Excel data into Microsoft Access


Import Microsoft Access data into Microsoft Excel

1	In Microsoft Access, open the file you want to export to Microsoft Excel.

2	Click the arrow next to the Office Links button, and then click Analyze It With MS Excel.


Import Microsoft Excel data into Microsoft Access

Before you begin this procedure, close the Microsoft Excel worksheet you want to import.

1	On the File menu, point to Get External Data, and then click Import from the submenu.

2	In the Import dialog box, select Microsoft Excel in the Files of Type box..

3	Use the Look In list to find the file you want.

4	Double-click the file you want to import.

5	Follow the directions in the Import Spreadsheet Wizard dialog boxes.


Copy Microsoft Access records to a Microsoft Excel worksheet

1	In Microsoft Access, open the table, datasheet, or query that contains the records you want to copy.

2	Switch to Datasheet view.

3	Select the records you want to copy.

4	Click  [image].

5	Switch to Microsoft Excel.

6	Click the cell where you want the first field name to appear.

7	Click  [image].

Microsoft Excel pastes the field names into the first row and pastes the records into the rows below.


Troubleshoot problems in Microsoft Excel with linked and embedded objects

I get an error message when I use the Change Source dialog box.

I can't copy a picture link from Microsoft Excel into another application.

I can't print embedded objects.

I can't update the automatic links in my Microsoft Excel worksheet.

When I double-click an embedded Microsoft Excel object, Microsoft Excel doesn't open.

In Microsoft Excel, all of the time values in my imported Microsoft Access table appear as the date 1/0/00.


I get an error message when I use the Change Source dialog box.

If you can't use the Change Source dialog box to edit the name or location of a link that has moved, click the cell that contains the link, and then edit the link in the formula bar.


I can't copy a picture link from Microsoft Excel into another application.

You may have copied a linked picture from an unsaved workbook.

1	Save the workbook the picture was copied from.

2	Switch to the application the picture was copied to.

3	On the Edit menu, click Links.

4	Click Change Source, and then click the name of the file saved in step 1.


I can't update the automatic links in my Microsoft Excel worksheet.

The Update Remote References check box may be cleared in the Tools Options dialog box (Calculation tab). Clearing this check box overrides the Automatic updating option in the Edit Links dialog box for links to external data sources (such as Microsoft Word documents or Microsoft Access databases).

To update an automatic link to an external data source, click Options on the Tools menu, click the Calculation tab, and then select the Update Remote References check box.

Note   Microsoft Excel workbooks are not external data sources.


I can't print embedded objects.

1	Click the embedded object.

2	On the Format menu, click Object, and then click the Properties tab.

3	Select the Print Object check box.


Troubleshoot problems in PowerPoint with linked or embedded Microsoft Excel objects

What do you need help with?

In PowerPoint, how can I make the background of my embedded Microsoft Excel objects transparent so that the colors on my slide show through?


In PowerPoint, how can I make the background of my embedded Microsoft Excel objects transparent so the colors on my slide show through?
In PowerPoint, how can I make the background of my embedded Microsoft Excel objects transparent so that the colors on my slide show through?

Unless the background of the Microsoft Excel worksheet or chart is clear, the background color of the PowerPoint slide won't show through. Use the following procedure to set a clear background for the Microsoft Excel worksheet or chart:

1	In Microsoft Excel, select the worksheet or chart.

2	For a worksheet, click Cells on the Format menu, and then click the Patterns tab.

For a chart, click Selected Chart Area on the Format menu, and then click the Patterns tab.

3	For a worksheet, click None in the Color box.

For a chart, select the None check box under Area.


Drag and drop information between applications

You can move or copy information between documents in different applications using drag-and-drop editing. Both applications must support object linking and embedding (OLE).

1	Arrange the application windows so that the source and destination documents are open and visible. You must be able to see the information you want to drag as well as the spot where you want to drop it.

2	Select the information you want to move or copy.

3	To move the information, point to the selected information, and then hold down the mouse button. When the [image] pointer appears, drag the pointer to the new location in the other application, and then release the mouse button.

To copy the information, hold down the CTRL key, point to the selected information, and then hold down the mouse button. When the [image] pointer appears, drag the pointer to the new location in the other application, and then release both the mouse button and the CTRL key.


Troubleshoot linking and embedding problems

What do you need help with?

When I double-click a linked or embedded object, a "cannot edit" error message occurs.

When I double-click an embedded Microsoft Excel object, Microsoft Excel doesn't open.

I want the embedded object rather than an icon to appear in my document.


When I double-click a linked or embedded object, a "cannot edit" error message occurs.

This message appears when the source file can't be opened.

•	Make sure that the application needed to edit the file is installed on your computer. If the application is not installed, you may be able to convert the object to a different file format that you can edit. For more information about converting an object to a different file format, click  [image].

•	Make sure that you have enough memory to run the source application. Close other applications to free up memory, if necessary.

•	If the source application is running, make sure that it doesn't have any open dialog boxes. Switch to the source application, and close any open dialog boxes.

•	If the object is linked, make sure that someone else doesn't have the source file open.

•	If the object is linked, make sure that the source file you want to edit still has the same name and has not been moved. Select the linked object, and then click the Links command on the Edit menu to see the name of the source file. If the source file has been renamed or moved, use the Change Source button in the Links dialog box to reconnect the links.


I want the embedded object rather than an icon to appear in my document.

1	Click the icon.

2	On the Edit menu, point to Object, and then click Convert.

3	Clear the Display As Icon check box.


Share information between Office applications

You can link or embed all or part of an existing file created in an Office application or in any other application that supports linking and embedding. You can also create a new object and then link or embed it. If the file you want to use was created in an application that does not support linking and embedding, you can still copy and paste information from the file, but you may not be able to link or embed from it.

The main differences between linking and embedding are where the data is stored and how it is updated after you place it in your file.

When you link, information gets updated if you modify the source file. Linked data is stored in the source file; the file into which you place the data stores only the location of the source and displays a representation of the linked data.

When you embed, information does not change if you modify the source file. Embedded objects become part of the container file itself. Double-clicking an object after you embed it opens the object in the source application. You can then edit it in place, and the original object in the source application remains unchanged.

What do you want to do?

Embed a new object

Link or embed an entire existing file

Link or embed selected information from an existing file


Embed a new object

To create an embedded object in another application, you must have the other application installed on your computer.

1	Click where you want to embed the new object.

2	On the Insert menu, click Object, and then click the Create New tab.

3	In the Object Type box, click the type of object you want to create.

4	To display the embedded object as an icon, select the Display As Icon check box.

Note   Only applications that are installed on your computer and that support linking and embedding appear in the Object Type box.


Link or embed an entire existing file

1	Click where you want to place the object.

2	On the Insert menu, click Object, and then click the Create From File tab.

3	In the File Name box, type the name of the object you want to link or embed.

To locate the file you want to link or embed, click Browse, and then select the options you want.

4	To display the embedded object as an icon, select the Display As Icon check box.

5	To maintain a link to the original file, select the Link To File check box.

Note   You cannot use the Object command on the Insert menu to insert certain types of files, including graphics. The commands used for inserting graphics vary among Office applications. To find the command you need, look up inserting pictures in online Help for the application in which you want to insert a graphic.


Link or embed selected information from an existing file

1	Select the information you want to link or embed.

2	Click  [image] or  [image].

3	Switch to the document in which you want to place the information, and then click where you want the information to appear.

4	On the Edit menu, click Paste Special.

5	To link the information, click Paste Link.

To embed the information, click Paste. In the As box, click the item with the word "object" in its name. For example, if you copied the information from a Word document, click Microsoft Word Document Object.

Note   When you link or embed an object in a Microsoft Access form or report, the object is displayed in an object frame. If the object you are embedding is from a Microsoft Access table, use a bound object frame. If the object is not stored in a table, use an unbound object frame.


Edit an embedded object

If the application in which you created an embedded object is installed on your computer, double-click the object to open it for editing. Some applications temporarily replace the menus and toolbars in the current application so that you can edit the embedded object in place, without switching to another window. Other applications start the original application in a separate window and then open the object for editing.

If you don't have the application in which an embedded object was created, convert the object to the file format of an application you do have. For example, if your Word document contains an embedded Microsoft Works Spreadsheet object and you don't have Works, you can convert the object to Microsoft Excel Workbook format and edit it in Microsoft Excel.

What do you want to do?

Edit an embedded object when I have the source application installed on my computer

Edit an embedded object when I don't have the application in which it was created


Edit an embedded object when I have the source application installed on my computer

1	Double-click the embedded object to open it.

2	Edit the object.

3	If you are editing the object in place, click anywhere outside the embedded object to return to the container file.

If you are editing the object in a separate application window, click either Exit or Quit on the File menu to return to the container file.

Note   Some embedded objects, such as video and sound clips, play when you double-click them, instead of opening an application for editing. To edit one of these objects, select it, point to Object Name Object on the Edit menu, and then click Edit.


Edit an embedded object when I don't have the application in which it was created

1	Select the object you want to edit.

2	On the Edit menu, point to Object Name Object (for example, Microsoft Works Spreadsheet Object), and then click Convert.

3	To convert the embedded object to the file format you've specified in the Object Type box, click Convert To.

To open the embedded object in the file format you've specified in the Object Type box, click Activate As.


Update a manual link

1	On the Edit menu, click Links.

The Links command is unavailable if your file contains no links.

2	Click the link, and then click the Update Now button.


Change the way a link is updated

1	On the Edit menu, click Links.

The Links command is unavailable if your file contains no links.

2	Click the link you want to update.

To select multiple links, hold down CTRL while you click each link.

3	To update linked information every time you open the file that contains the link and any time the linked information changes while your file is open, click Automatic.

To update linked information only when you click Update Now, click Manual.


Deciding which application to use to create an online or printed form

You can create a form in Word, Microsoft Access, or Microsoft Excel. All three applications provide sample forms you can use "as is" or as a starting point for creating custom forms. For example, Word provides several common online business forms, including invoice, purchase order, and weekly time sheet forms. In addition, Microsoft Access provides a Form Wizard that asks questions and then uses your answers to automatically lay out and format your form.

•	Use either Word or Microsoft Access to create a form that contains complex formatting, pictures, linked or embedded objects, check boxes, drop-down lists, and text areas that have specific data types, formatting, and default text. In either application, you can create forms that are filled in online or forms that are printed and then filled in on paper. In either Word or Microsoft Access, you can set conditions for adding data to the form, include macros that run automatically, and you can provide Help messages to make it easier for users to complete the form.

•	To generate a variety of reports from your data or to collect a large amount of information, use Microsoft Access. You should also use Microsoft Access if your form contains complex expressions or if you need full relational database capabilities.

•	To collect information for use in calculations, analysis, or financial documents (for example, a mortgage table or customer quotes), create your form in Microsoft Excel. You can also use a Microsoft Excel form to collect information and store it in a Microsoft Access database. After you create the form, run the AutoTemplate Wizard in Microsoft Excel to turn your form into a template that's easy to find and use.


Making a list of names and addresses for a mail merge

Before you create a list of names and addresses for a mail merge, you need to determine which Office application is suited to your task. For a mail merge, you can use a list you create in Word, Microsoft Access, Schedule+, or Microsoft Excel.

•	For a small- or medium-size list of names and addresses in which you don't expect to make many changes, click Create Data Source in the Word Mail Merge Helper.

•	To use the names and addresses in your Schedule+ Contact List, use the Word Letter Wizard.

•	For an automatically numbered list, use Word.

•	For a longer list—where you expect to add, delete, and change entries—or for a list of numbers, use Microsoft Excel.

•	For powerful sorting and searching capabilities, use either Microsoft Access or Microsoft Excel.

•	For a list with full relational database capabilities, for a large list, or for a list you can share with others, use Microsoft Access.


Deciding which Office application to use to create a table

Before you create a table, you need to determine which Office application is best suited to your task. To create a table, you can use Word, Microsoft Excel, or Microsoft Access. All three applications can automatically format the table for you.

•	For a table that includes complex formatting such as bulleted lists, custom tabs, numbering, or hanging indents, use Word.

•	For a table that includes complex calculations, statistical analysis, queries, or charts, use Microsoft Excel. However, if your table entries will exceed 255 characters in length, do not use Microsoft Excel; instead, use Word or Microsoft Access.

•	For powerful sorting and searching capabilities, use either Microsoft Access or Microsoft Excel.

•	If you need full relational database capabilities, create your table in Microsoft Access.

•	For a table that you can easily include in a PowerPoint presentation, use Word.


Importing or converting files from another Office application

To convert most types of files that were saved in another format, simply open the file in the Office application you want to use. When the Office application recognizes the file format, it converts the document and opens it. For example, you can open a Word document in PowerPoint, and PowerPoint will automatically convert the Word document to PowerPoint file format.

In some cases, you must first open the file in the source application and save it in the file format of the other application. After the source file is converted, you can open it directly in the other application. For example, to transfer a Microsoft Access database table to Microsoft Excel, click the Analyze It button in Microsoft Access to open the database table, save it in Microsoft Excel file format, and then open the file directly in Microsoft Excel.

Note   For information about which file formats an application can import or export, look up convert in that application's online Help. If you did not install a necessary file converter, run Office Setup again, adding the converters you need.


The format of information pasted from the Clipboard

Information you cut or copy to another application is pasted, if possible, in a format that the application can edit. For example, data from Microsoft Excel worksheets and records from Microsoft Access are pasted into Word as Word tables, complete with column widths and font formatting. Text from Word is pasted into Microsoft Excel as editable text, and records from Microsoft Access are pasted into a Microsoft Excel worksheet as rows, with each field in a separate column.

If an application can't edit the information, it embeds it as an object. You can use the source application to edit embedded information. If the information can't be embedded, it is pasted as a static picture that cannot be edited.

Note   To control how information is pasted, use the Paste Special command on the Edit menu.


When I double-click an embedded Microsoft Excel object, Microsoft Excel doesn't open.

You probably have the Ignore Other Applications check box selected, which causes Microsoft Excel to ignore all requests from other applications. Use the following procedure to turn off the Ignore Other Applications check box.

1	In Microsoft Excel, click Options on the Tools menu, and then click the General tab.

Clear the Ignore Other Applications check box.


Install or remove individual components of Microsoft Office

1	Close all open applications.

2	If the Office Shortcut Bar is available, click the area with the small button at the extreme left or top of the Office Shortcut Bar, and then click Add/Remove Programs.

If the Office Shortcut Bar is unavailable, point to Settings on the Windows Start menu, and then click Control Panel. Double-click Add/Remove Programs, and then click the Install/Uninstall tab. Click the Office application, and then click Add/Remove.

3	Follow the instructions on the screen.

Notes

•	If you originally installed the application from a network file server or a shared folder, run that copy of the Setup program.

•	To add or remove components of Office on Windows NT, start Office Setup the same as when you first installed Office, and follow the instructions on the screen.


Troubleshoot problems in Word with linked or embedded Microsoft Excel objects

What do you need help with?

When I paste link a Microsoft Excel worksheet into a Word document, Word inserts an extra paragraph mark above the link. I can't delete the paragraph mark.

Word changes the font size of the data I paste from Microsoft Excel.

After I save my Microsoft Excel worksheet in Word, I can't open it in Microsoft Excel.

In Word, I'm having trouble scaling an embedded Microsoft Excel chart object.

The cell alignment is wrong in some of the Microsoft Excel worksheets I pasted into Word.

When I drag a framed, linked Microsoft Excel worksheet to another location in my Word document, it appears twice in my document instead of once.


When I paste link a Microsoft Excel worksheet into a Word document, Word inserts an extra paragraph mark above the link. I can't delete the paragraph mark.

Although you can't delete the extra paragraph mark, you can make it very small by changing the line spacing setting to Exactly 0.01". To change line spacing, click Paragraph on the Format menu.

Note   The extra paragraph mark does not appear if you paste the worksheet instead of linking it.


Word changes the font size of the data I paste from Microsoft Excel.

Word changes 10-point text pasted from Microsoft Excel to the default font size used by Word. It does not change the typeface, nor does it change any text with a font size other than 10 points.

For example, if the default font (Normal style) in Word is Times New Roman 12-point, all Arial 10-point text in Microsoft Excel changes to Arial 12-point text when you paste it into Word. This change occurs only when you paste the data. It does not occur if you embed or link the Microsoft Excel data.

To have 10-point text from Microsoft Excel remain 10-point text when you paste it into Word, change the font size of the Normal style in Word to 10 points before you paste the Microsoft Excel data. After you paste the data, you can change the Normal style font size in Word back to the original setting.


After I save my Microsoft Excel worksheet in Word, I can't open it in Microsoft Excel.

Word can open (import) Microsoft Excel files, but it can't save (export) in Microsoft Excel format. If you save a Microsoft Excel Worksheet in Word, the file becomes a Word Document file. To edit and save changes to a Microsoft Excel worksheet, don't save it in Word; instead, open, edit, and save the worksheet in Microsoft Excel. Then open it again in Word.

If you then save the worksheet in Word Document format, Word replaces the Microsoft Excel file with a Word document file, which Microsoft Excel can no longer read. If your file was a Microsoft Excel workbook, all of the workbook contents are lost.

To edit and save changes to a Microsoft Excel worksheet, don't save it in Word; instead, open, edit, and save the worksheet in Microsoft Excel. Then open it again in Word.


In Word, I'm having trouble scaling an embedded Microsoft Excel chart object.

When you resize an embedded Microsoft Excel chart sheet in a Word document, the chart plot area may be resized while the chart text, chart legend, and object frame remain unchanged. This happens if the EMBED field in Word contains the \s switch, which returns an embedded object to its original size when you update the field.

When you resize a Microsoft Excel embedded chart, the chart in the object appears off center, the Microsoft Excel worksheet cells are visible, and the chart object frame returns to its original size. This happens partly because of the \s EMBED field switch, and partly because an embedded chart includes Microsoft Excel worksheet cells as well as the embedded chart. This makes the embedded object behave more like a Microsoft Excel Worksheet object than a Chart object.

Use the following procedure to remove the /s switch from either type of embedded chart so that you can resize the chart in Word without distorting the chart components or displaying cells from the underlying worksheet:

1	Select the embedded chart in Word.

2	Press SHIFT+F9 to display the field code instead of the object. The field code appears as follows:

{EMBED Excel.Chart.5 \s}

3	Delete " /s" from the field code so that it appears as follows:

{EMBED Excel.Chart.5}

4	With the field code still selected, press F9 to update the field, and then press SHIFT+F9 to display the chart object.

5	Size the chart object.

Tip   For best results in Word, embed a chart sheet rather than an embedded chart whenever possible, and size the chart in Microsoft Excel before you embed it in Word.


The cell alignment is wrong in some of the Microsoft Excel worksheets I pasted into Word.

Word does not support vertical alignment for table cells, so it does not retain center or bottom vertical alignment formatting that was applied in Microsoft Excel. To change the vertical alignment in Word, use paragraph formatting commands. You can also paste the worksheet as a picture rather than as formatted text.

When you link the Microsoft Excel worksheet, Word adds a formatting switch that maintains any formatting you apply to the worksheet in Word. If you change the alignment of cells in Microsoft Excel and then update the link in Word, the new alignment does not appear in Word.

•	To change the alignment of the cells in Microsoft Excel and have the changes appear in Word each time you update the link, delete the mergeformat option and its formatting switch from the LINK field in Word. The worksheet in Word reverts to the alignment of the cells in the Microsoft Excel worksheet each time you update the link in Word.

•	To change the alignment of the worksheet in Word so that it does not revert to the Microsoft Excel alignment when you update the link, leave the LINK field in Word unchanged and change the alignment formatting in Word.

•	To change the alignment in Microsoft Excel but preserve any subsequent alignment changes made in Word, delete and then reinsert the LINK field.


When I drag a framed, linked Microsoft Excel worksheet to another location in my Word document, it appears twice in my document instead of once.

The worksheet appears twice if the field result, rather than the field code, is displayed when you frame the LINK field. Word frames the worksheet (the field result) but not the field. Consequently, when you drag the framed field result, you drag a framed picture of the worksheet but you leave the unframed LINK field behind. If you later update the LINK field, a new, unframed copy of the worksheet appears in the original location.

Delete the unlinked, framed copy of the worksheet. Then frame both the LINK field and its picture result. To do this, in Word press SHIFT+F9 to display the field code, and then select the LINK field before you frame the worksheet. If you frame the LINK field with its picture, they will stay together when you drag them to a new location in Word.


Answers to common questions

Automated answers to common questions, solutions to technical problems, and tips are available at no cost — 24 hours a day, 7 days a week — by telephoning Microsoft FastTips. For more information about FastTips information services, click  [image].


Sending feedback on user assistance

The Answer Wizard senses that your question hasn't been answered to your satisfaction. In creating the Answer Wizard, our goal is to provide you with the assistance you need, when you need it. If the Answer Wizard hasn't provided you with the information you need, please let us know. Your feedback can help us refine future versions.

You can send feedback by electronic mail to:

•	offc95ua@microsoft.com

Or you can send a letter to:

•	Office UA Feedback
Microsoft Corporation
1 Microsoft Way
Redmond, WA   98052
USA

Tell us the question or questions you asked. Tell us what didn't work. The more details you provide, the better we can make adjustments in the future. We look forward to hearing from you!

The Microsoft Office User Assistance Team


Where the Answer Wizard wants to go

The Answer Wizard wants to go wherever you do. If you need help, ask the Answer Wizard about the task you're working on. The Answer Wizard can take you right to the tools you need, and it will tell you how to use them when you get there.


Make my computer smile

1	Type a colon (:).

2	Type a right parenthesis[ ) ].

Repeat steps 1 and 2 until the desired level of machine happiness is achieved.


Find Fast dialog box options

Index For Documents In And Below

Displays status information for each indexing task, including the drive, share, and folder location of the indexed documents.


Index menu commands in Find Fast

Create Index command

To create a new Find Fast index, click Create Index.

Update Index command

To update a Find Fast index, click Update Index.

Delete Index command

To delete a Find Fast index, click Delete Index.

Show Indexer Log command

To display a log of ongoing and completed Find Fast indexing tasks, including any errors encountered, click Show Indexer Log. To return to Find Fast, click Exit on the File menu.

Pause Indexing command

To temporarily stop Find Fast indexing, click Pause Indexing. To restart Find Fast indexing during the current computer session, click Pause Indexing again. Find Fast indexing automatically restarts when you restart your computer.

Cancel Selected Task command

To cancel an indexing task, click the task under Index For Documents In And Below and then click Cancel Selected Task.

Close command

To quit Find Fast, click Close.


Create a new Find Fast index

1	On the Windows Start menu, point to Settings, and then click Control Panel.

2	Double-click  [image].

3	On the Index menu, click Create Index.

4	In the In And Below box, specify the path for the documents you want Find Fast to index.

To create a Find Fast index for the contents of documents located in a specific folder on the local drive or on a network share, click Browse to specify the folder or network share you want.

5	In the Of Type box, click the type of document you want Find Fast to index.

Tips

•	It's more efficient to create a Find Fast index for an entire drive or top-level folder than to create smaller indexes for subfolders.

•	To index documents created in another application, such as Lotus 1-2-3 or Word Perfect, click All Files in the Of Type box. Make sure that you've installed the appropriate file format converter. For more information, click  [image].

•	To change the scope of a Find Fast index — for example, to change the file type, or to index all the documents instead of only those located in or below a specific folder on the local drive — you must delete the original index before you create the new one. For more information, click  [image].

Note   Before you create an index on a network share that's maintained by a system administrator, you should check with the system administrator. A Find Fast index is about 5 percent of the size of the indexed documents.


Update a Find Fast index

1	On the Windows Start menu, point to Settings, and then click Control Panel.

2	Double-click  [image].

3	On the Index menu, click Update Index.

4	In the In And Below box, click the path for the documents for which you want to update the Find Fast index.

To update a Find Fast index that doesn't appear in the list, click Browse. You can select any folder, drive, or network share that you specified when creating an index.

Tip   You can click Information to display information about the Find Fast index selected in the In And Below box, such as the date last updated, the number of documents indexed, and the size of the index.

Note   You won't have to update indexes in the future if the Continue To Update Automatically check box remains selected.


Delete a Find Fast index

1	On the Windows Start menu, point to Settings, and then click Control Panel.

2	Double-click  [image].

3	On the Index menu, click Delete Index.

4	In the In And Below box, click the location of the Find Fast index you want to delete.

To delete an index that doesn't appear in the list, click Browse. You can select any folder, drive, or network share that you specified when creating an index.

Tip   The information about the Find Fast index selected in the In And Below box—such as the date last updated, the number of documents indexed, and the size of the index—appears in the dialog box.


View a log of Find Fast indexing tasks

1	On the Windows Start menu, point to Settings, and then click Control Panel.

2	Double-click  [image].

3	On the Index menu, click Show Indexer Log.

4	To return to Find Fast, click Exit on the File menu.


Cancel or temporarily stop Find Fast indexing tasks

1	On the Windows Start menu, point to Settings, and then click Control Panel.

2	Double-click  [image].

3	To cancel a scheduled indexing task, click its path under Index For Documents In And Below, and then click Cancel Selected Task on the Index menu.

To temporarily stop all index creation and updating, click Pause Indexing on the Index menu.

Tip   To restart background indexing during the current session, click Pause Indexing on the Index menu again. Find Fast indexing automatically restarts when you restart your computer.


Add or delete shortcuts in the Microsoft Network dialog box

1	Connect to The Microsoft Network.

   How?

2	In The Microsoft Network, locate the topic you want to add to the Microsoft Network dialog box.

3	Using the right mouse button, click the topic icon, and then click Create Shortcut.

The Microsoft Network places a shortcut icon on your desktop.

4	Drag the shortcut icon from the desktop to the MSN toolbar on the Office Shortcut Bar.


Finding information in the Microsoft Knowledge Base

To find the technical information you need in the Microsoft Knowledge Base (KB), compose a text query that includes the elements in the following table.

Enter this element	By typing, for example
Topic	shortcut bar or pie chart
Application name	office or word
Application version	7.0 (for information about Word version 7.0)
Operating system	windows 95
KB keywords	kbprint (for information about printing) KB articles about the same topic are grouped by keyword. For a list of keywords, search the KB using kbkeyword. For a list of keywords for a specific Microsoft product, search the KB using kbkeyword and product name — for example, kbkeyword and excel.
Logical operators: AND, OR, NOT	print AND (landscape NOT portrait) AND laserjet AND (iiisi OR 4si) Use AND to return articles that contain the expressions on both sides of AND. Use OR to return articles that contain the expressions on one or both sides of OR. Use NOT to exclude articles that contain the expression following NOT.
Grouping operators:  " " (quotation marks),  ( ) (parentheses)	(explorer OR "my computer") AND "start button" Enclose phrases longer than one word in quotation marks. Enclose an expression in parentheses to change its evaluation order — for example, to evaluate an OR expression before an AND expression. (In the absence of parentheses, AND expressions are evaluated before OR expressions.)
Tip   Some Microsoft products offer KB articles in Windows Help file format. To access a list of these Microsoft products, search the KB using the keywords kbfile and help.

For more information about how to access the Microsoft Knowledge Base, click  [image].


Connect to Microsoft technical resources

If you have a question about an Office application, first look in the Getting Results books, the Answer Wizard, or the Readme file that comes with the application. If you don't find what you need, you can get information from several Microsoft technical resources, including online support forums, the Microsoft Knowledge Base (KB), Microsoft Software Library (MSL), Microsoft Download Service (MSDL), the Microsoft TechNet and Microsoft Developer Network CD-ROMs, and Microsoft Press publications.

If you have a modem, you can automatically connect to most of these resources by clicking The Microsoft Network on the Help menu in any Office application.

Where do you want to go for technical information?

The Microsoft Network (for KB, MSL, support forums, and more)

Microsoft FastTips (for popular KB articles and recorded, faxed, or mailed technical information)

Microsoft Download Service (MSDL)

The Internet (for KB, MSL, and more)

CompuServe, America Online, and GEnie (for KB, MSL, support forums, and more)

Microsoft TechNet and Microsoft Developer Network CD-ROMs (for KB, MSL, technical white papers, and more)

Microsoft Press (for technical publications)


The Microsoft Network

If you have a modem, you can quickly connect to The Microsoft Network (MSN) from any Office application.

1	On the Help menu, click The Microsoft Network.

2	Click where you want to go on The Microsoft Network, and then click Connect.


Microsoft FastTips

Microsoft FastTips gives recorded or faxed answers in English to common technical problems. You can also order Application Notes and popular articles from the Microsoft Knowledge Base (KB) by fax or mail.

Microsoft FastTips is available 24 hours a day, 7 days a week, by calling (800) 936-4100, toll-free, from a touch-tone telephone. Using the buttons on your telephone, follow the prompts to hear recorded answers to your technical questions, obtain a catalog of available information, or order items by fax.


Microsoft Download Service

To connect to the Microsoft Download Service (MSDL) bulletin board system, use your modem to call (206) 936-6735 in the United States or (905) 507-3022 in Canada, and then follow the prompts. This service is available 24 hours a day, 7 days a week.

Note   MSDL supports 1200-, 2400-, 9600-, and 14,400-baud (V.32 and V.42) data transmission with 8 data bits, 1 stop bit, and no parity. The protocols that MSDL supports are Xmodem, Xmodem-1K, Ymodem (batch), Kermit, Super Kermit (Sliding Windows), and Zmodem.


The Internet via World Wide Web, FTP, or Gopher

You can access the Microsoft Knowledge Base (KB) and Microsoft Software Library (MSL) at any of the following three Internet sites:

•	Microsoft World Wide Web site, located at www.microsoft.com

•	Microsoft Gopher site, located at gopher.microsoft.com

•	Microsoft FTP site (which supports anonymous logon), located at ftp.microsoft.com

The KB at the World Wide Web and Gopher sites provides full-text searches and automatic links to files on the MSL so you can download files directly from KB articles.


CompuServe, America Online, and GEnie

The Microsoft Knowledge Base (KB) and Microsoft Software Library (MSL) are available on the CompuServe, America Online, and GEnie information services. CompuServe also hosts Microsoft forums where you can interact with other users and Microsoft support personnel.

CompuServe

•	To access the Microsoft Knowledge Base, type go mskb at any ! prompt.

•	To access the Microsoft Software Library, type go msl at any ! prompt.

•	To access Microsoft forums, type go microsoft at any ! prompt.

America Online

•	To access the Microsoft Knowledge Base, click Keyword on the Go To menu, type microsoft in the Enter Word(s) box, and then click Go. In the Microsoft Resource Center, click Knowledge Base.

GEnie

•	To access the Microsoft Knowledge Base, type m505 at the GEnie system prompt.


Microsoft TechNet and Microsoft Developer Network

To get the Microsoft Knowledge Base (KB), Microsoft Software Library (MSL), and other technical information on CD, you can subscribe to two different services — Microsoft TechNet and the Microsoft Developer Network (MSDN).

To subscribe to Microsoft TechNet, call (800) 344-2121. To subscribe to the MSDN, call (800) 759-5474. Both numbers are toll-free in the United States and Canada.


Microsoft Press

Microsoft Press offers a wide variety of technical publications about Microsoft products and related computer technologies. These publications include development kits, resource kits, the Step by Step and Running... series of how-to books, Field Guide reference books, programming books, and more. You can get Microsoft Press books from your local bookstore or by calling (800) MSPRESS, or (800) 677-7377.