Troubleshooting Microsoft® Office XP

Author Nancy Stevenson and Elaine Marmel Pages 576 Disk N/A Level Beg/Int Published 01/02/2002 ISBN 9780735614918 ISBN-10 0-7356-1491-1 Price(USD) $29.99 To see this book's discounted price, select a reseller below.	More Information About the Book Table of Contents Sample Chapter Index Related Series Related Books About the Author Support: Book & CD Rate this book

Table of Contents

About this book	xvii
How to use this book	xvii
Troubleshooting tips	xix
How to troubleshoot	xix
PART 1: COMMON ELEMENTS	3
AutoRecover and file repair	4
Quick fixes Backing up files         Enabling AutoRecover	4
I need to restore a file that was damaged	6
The AutoRecover feature doesn't recover my file when I restart	8
My file was recovered but it doesn't contain my changes	10
Clip art	14
Quick fixes When you can't get Clip Organizer to work         Resizing clip art	15
I don't see the pictures I added to Microsoft Clip Organizer	16
I can't select all the pieces in my clip	18
When I search for clips I get too many results and they aren't what I want	20
The clip I want isn't in Clip Organizer	22
Drawing	24
Quick fixes Using fill effects         Getting smooth colors	25
I can't see the border around an object	26
I inserted a drawing, but I don't see it	28
I can't resize an object	30
Editing	32
Quick fix Delete one item from Office Clipboard	32
I want to change the behavior of Office Clipboard	34
Office programs are not selecting text the way I expect	36
AutoCorrect isn't functioning as I expect	38
Help	40
Quick fixes Redisplay the Office Assistant         Disable the Office Assistant         Hide the Office Assistant	40
I want to adjust the behavior of the Office Assistant	42
My Office program won't let me switch to a different Office Assistant	44
I can't find the Help topic I want in the Office Assistant	46
Menus and toolbars	48
Quick fix Displaying ScreenTips on toolbar buttons	48
Some tools and menu commands have disappeared	50
There's a tool I use all the time, but it isn't on the Standard toolbar	52
I need to see more of my document on the screen	54
Printing	56
Quick fixes Selecting what to print         Changing page orientation	57
I try to print, but nothing happens	58
When I print, the text runs all the way to the edge of the paper	60
Printing takes a long time	62
Reviewing changes	64
Quick fixes I don't see changes in a PowerPoint presentation         The reviewer's name is "unknown"         The reviewer's name disappears when you save	64
My Office program stops responding when I try to collaborate on a document	66
I don't know which command to use to e-mail a document, spreadsheet, or presentation	68
Changes made in my Word document are not being tracked	70
No changes appear in my Excel workbook, even though I turned on Track Changes	72
Changes don't appear on the History worksheet	74
Searching	76
Searching for files takes a long time	78
My searches don't display information that I know exists	80
When I search, I don't find the files I expect to find	82
I don't understand how to use natural language searching	84
Sharing data	86
Quick fix The type of object I want to embed doesn't appear in the Insert Object dialog box	87
I try to edit an HTML file in one Office program, but it opens in another	88
I get an error message when I double-click a linked or embedded object	90
When I try to import information into Outlook from Excel, I get an error message	92
I need to exchange information between Word and Access	94
When I click a hyperlink, I don't go to the expected destination	96
I'm having trouble inserting outlines from other programs into PowerPoint	97
Spelling	98
Quick fix Clicking Change All doesn't change all occurrences of a misspelling	99
The spelling checker missed errors in my document	100
I accidentally added a word to a custom dictionary, and I want to delete it	102
I accidentally added a word as an AutoCorrect entry, and I want to delete it	104
I don't want to see the wavy red lines that appear underneath words	105
Templates and styles	106
Quick fix Share templates using your network	107
I can't use the custom template I created	108
I am having trouble making a template available for others to use	110
When I open an Office program, warnings about installed templates and add-ins appear	112
I am having trouble copying one object's formatting to another object	114
Web publishing	116
Quick fixes Obtaining correct positioning of text and graphics on Web pages         Automatic backing up of Web pages	117
People can't find the Web page I saved on a file server	118
When I saved a Web page, my Office application created a bunch of picture files	120
I try to open an HTML file, but it opens in another Office application	122
PART 2: EXCEL	125
Charts	126
Quick fix User-defined chart types	126
My chart didn't update when I added new information on the worksheet	128
I plotted dates on my chart, and I see gaps between the dates on the horizontal axis	130
I don't get a time-scale horizontal axis even though I'm using dates in my chart	131
The horizontal axis of my chart doesn't display all of the axis labels	132
When I resize a chart, the font sizes change	133
Editing data	134
Quick fixes The shadow disappeared         If you apply a text format to a number	135
My data isn't sorting the way I'd expect	136
I want to use the Fill handle to copy numbers, but I don't see it	138
Borders disappear across page breaks or around objects	140
I changed the properties for a shadow effect, but I don't see the new settings on new objects	141
The results of formulas are wrong after I move or copy cells	142
I expect arrow keys and directional keys to do one thing, but they do something else	143
Entering and selecting data	144
I'm having trouble renaming a worksheet tab	146
I've typed values and dates into cells, but they don't display correctly	148
I can't see information in some cells	150
I don't know what special characters in my workbook mean	152
Sometimes Excel copies information once and other times repeatedly	153
After I select cells, if I click or press directional keys, my selection is cancelled or grows	154
Formatting worksheets	156
Quick fixes To remove decimal points from numbers you've already entered         To stop adding decimal points to numbers as you enter them	157
Numbers don't seem to behave like numbers	158
I want to format based on conditions I specify	160
I don't know how to create a custom number format	162
Formulas and functions	166
Quick fix To see details and examples of functions	167
I need help correcting formulas	168
I see an error message instead of the formula's result	170
I need help constructing a function	172
Importing and exporting	174
I need to get Excel information into FrontPage	176
I created a PivotTable in Access that I want to include in an Excel worksheet	178
I want to import Access data into Excel	180
I have information in Excel that I want to export to an Access database	182
Protecting workbooks	184
I don't want anyone to open or edit my workbook	186
I want to let others use my workbook, but I don't want them to change the structure	187
The Protect Workbook command isn't available	188
I want to protect parts of my workbook, but allow users to change other parts	190
I want to allow users to change protected ranges	192
Sharing workbooks	194
When I turn on change tracking, others can edit my workbook	196
I can only get read-only access to a shared file	198
I'm getting a message that says I'm no longer connected	200
I made changes and they've disappeared	202
PART 3: OUTLOOK	205
Address Book and contacts	206
Quick fix Selecting address books	207
When sending e-mail messages, Outlook takes a lot of time to resolve names	208
I try to open a contacts folder in Address Book but Outlook displays a message that the folder can't be found	210
The address book I use most often isn't the one that opens first in Address Book	213
Attachments	214
Quick fix Printing an attachment	215
The recipient of my e-mail can't open the file I attached	216
I changed an attachment but my changes have disappeared	218
I don't know how to attach one e-mail message to another	220
E-mail accounts	222
Quick fix Retaining copies of your e-mail messages	222
I got an "Undeliverable" message from my e-mail administrator	224
I have to log on to my POP3 server before I can get my e-mail: how can I skip that step?	226
I want to receive the replies to my messages at another e-mail address	228
I got a message about a server timeout	230
Importing and embedding	232
Quick fix Viewing an embedded object	233
When I try to import data from Excel, I get an error message	234
When I send an e-mail, an embedded object in it disappears	236
I want to insert just part of a file, but Outlook inserts the whole thing	238
I get a "cannot edit" error message when I double-click an embedded object	240
Meetings	242
Quick fixes Joining a NetMeeting         When Call Using NetMeeting is unavailable	243
I scheduled a meeting but haven't received any responses	244
My online NetMeeting settings are unavailable	246
I'm receiving meeting responses, and I don't want to	248
Public folders	250
Quick fixes Searching in public folders          Large Outlook folders	251
I had items in my public folder that just disappeared	252
Changes I made to a file in a public folder weren't saved	254
One of my public folders contains conflict messages	256
Rules	258
Quick fix Working with Rules Wizard	259
I want to create a rule that applies to only one e-mail account, not all of them	260
I can't find a rule I created in the Organize pane in one of my inboxes	262
I don't know how to import a copy of all my rules into Outlook	264
Security	266
Quick fixes Security label settings         Working with message formats	266
Outlook won't send an encrypted message	268
I received a secure message, but I can't open it	270
When I try to send secure e-mail, I get a message about my security policy	272
Sending and receiving e-mail messages	274
Quick fix Getting permission to access e-mail	275
Sending and receiving e-mail takes a long time	276
I need to recall or replace a message I've already sent	278
I only see some of my messages	280
E-mails sit in my Outbox and don't get sent	282
Tasks and calendars	284
Quick fixes Printing weekdays only         Fitting a calendar into a printout	285
My appointments and meetings show at wrong times	286
I entered a task in hours, but it's not converting to days and weeks correctly	288
I keep getting reminders for an appointment or meeting that's in the past	290
PART 4: POWERPOINT	293
Aligning and arranging objects	294
Quick fixes Nudging objects         Using Align Or Distribute	294
I inserted several objects, but they overlap each other	296
Objects aren't moving where I want them when I try to align or distribute them	298
An object on my slide is upside down!	300
Copying, pasting, and moving	302
Quick fixes Copying several objects at once         Copying a Word outline into PowerPoint	302
When I copied a slide, all the formatting disappeared	304
There's an object on my slide that I can't move	306
I pasted data from Excel in my slide, and it doesn't update when I make changes in Excel	308
Drawing objects and pictures	310
Quick fixes Grouping objects         Adding color to a 3-D object	310
I can't see the shadow I applied to my drawing object	312
I'm having trouble cropping a picture	314
I want to edit an embedded object, but the program it was created in isn't available	316
Links and embedded objects	318
Quick fix Working with hyperlinks	319
There's a link in my presentation that PowerPoint can't update	320
The gridlines in my embedded Microsoft Word table don't appear on my slide	322
I inserted a sound clip on a slide, but I don't want the icon to appear	324
Masters	326
Quick fixes Working with Title Master         Working with footers in Slide Master	326
I deleted a placeholder on a Master slide and don't know how to get it back	328
I added a picture to a Slide Master, but it doesn't appear on some of my slides	330
I applied a different font on a Slide Master, but fonts on a few of my slides didn't change	332
Multimedia	334
Quick fix Improving movie playback	335
I added a movie to a slide, but a message says PowerPoint can't play the file	336
My QuickTime movie won't play	338
I want to add a sound to a slide, but I don't know how	340
Notes and handouts	342
Quick fixes Printing more slides on handouts         Formatting notes	343
I want to use more than one Notes Page for a slide	344
I want to print a three-slides-per-page handout, but I don't want those ruled lines	346
I'm trying to insert a graphic in Notes but it doesn't work	348
Printing	350
Quick fix Managing presentation fonts	351
I printed my presentation in black and white, but it looks odd	352
I want to print my entire presentation, but I get a message that some of my slides are hidden	354
When I print a Notes Page, I get a border I don't want	356
Running a show	358
Quick fix Pack And Go Wizard	359
I'm not getting any sound	360
My slide show is running very slowly	362
Nothing's projected on the screen	364
Slide design and layout	366
Quick fix Adding graphics to notes	367
I don't know how to replace all occurrences of one font with another	368
Font styles that were on my computer disappear when I show my presentation on another computer	370
There are too many placeholders on my slide	372
There's a graphic I can't move or delete	374
Text boxes and text in objects	376
Quick fix Text boxes in Photo Albums	377
When I flip, move, or rotate a shape, the text in it doesn't move	378
I have trouble getting shapes and text to fit together	380
I created a text box, but its contents don't appear in the outline	382
Transitions and animations	384
Quick fixes Improving animation performance         Choosing the best animations	385
An item I animated in my slide is labeled with a "1," but it doesn't play first	386
The option to play an animation effect with a mouse click isn't available	388
I don't see animations when I run my Web presentation	390
Publishing to the Web	392
Quick fixes Saving broadcasts         Working with presentation broadcasts	392
I want to open a PowerPoint file on a Web server, but I don't know how	394
I want to make changes to a published presentation, but I don't know how	396
I can't send my Web presentation as an e-mail attachment	398
PART 5: WORD	401
Borders and numbered lists	402
Quick fixes To add text without adding bullets or numbers         To modify borders or shading for table cells         To remove shading from the background of a page	402
My headings aren't numbered even though I'm using Outline Numbering	404
Part of a page border prints, but part doesn't print	406
I see strange bullet characters	408
I changed the bullets in a list, but only some bullets changed	410
My page borders don't appear on every page	411
Envelopes	412
Quick fix If Word doesn't display the address in your letter when you open the Envelopes And Labels dialog box	413
I put envelopes in the printer tray, but Word still prompts me to feed envelopes manually	414
I want to permanently use a different font for addresses than the one that appears in my document	416
I want to use the POSTNET barcode, but I don't know how	418
Trading data with other programs	420
I have a table in Word that contains information I need in Access	422
I need to get information from FrontPage into a Word mail merge document	424
The information for my Word mail merge data source is in an Excel file	426
Mail merge	430
Quick fixes To merge e-mail from Outlook after receiving a security warning         To print data instead of merge fields         To restore a main merge document to a Normal document	430
After I merge, my document has extra blank lines that I don't want	432
Some address information is missing for some recipients	436
My merged document contains information I don't want in it	440
Opening and saving files	444
Quick fixes You'll get two extensions on your file name         Word replaces right-aligned tabs in tables with spaces         If the file format you need doesn't appear in the Save As box	445
I'm trying to convert text and graphics, but I'm having trouble with the graphics	446
I get an error message when I try to save a document	448
I know I saved my document, but my changes don't appear in it	449
Page formatting	450
Quick fixes The spacing changed when you deleted text         To set up different odd and even headers or footers for a one-page template	450
I have page breaks in my document that I don't want	452
The headers and footers have disappeared or contain inaccurate information	454
My page numbers are missing on screen, or I see {PAGE} instead of my page number	456
Line numbers don't appear on my screen or on the printed page	458
I changed the header in one section, and all headers in the document changed	460
Printing	462
Quick fixes If only a few headings print per page in Outline view         To avoid different page numbers and headers appearing at the beginning of each section when you print a master document	463
Text still prints on the same page, even though I inserted a manual page break	464
I don't see my document background when I print	465
My document contains graphics that don't print	466
The appearance of printed text and on-screen text isn't the same	468
Security and macro warnings	472
Quick fixes If you can't change the macro security level         If you signed macros using the SelfCert tool	473
Wizards, custom commands, and macros that used to work don't work	474
When I open Word, I see warnings about expiring digital signatures	476
I get warnings about macros being disabled for the current template	478
I want to update the list of trusted sources with a new certificate	480
Text editing	482
Quick fixes To change typing and editing options         To stop selecting text when you click the mouse or press a key         To stop selecting the paragraph mark when you select a paragraph         If text is disappearing as you type	482
Settings don't hold or features behave unexpectedly	484
I'm having trouble with Click and Type	488
An AutoText entry is missing	490
Text formatting	492
Quick fixes To avoid changing or losing character formatting         You can see the Style area         You can view styles from other templates using the Style Gallery	492
The formatting of a style is suddenly different	494
I applied the same style to different paragraphs, and they look different	496
My styles won't copy to other documents or templates	497
I need to underline a blank line or a space, but I can't figure out how to do it	498
Web pages	500
Quick fixes If horizontal scroll bars do not appear in your Web frames page         You can't delete a frame with the Undo command	501
Instead of my Web page content, <HTML> or other tags appear	502
I'm having trouble with hyperlinks	504
When I save as a Web page, some text and graphics change positions	506
My document appears in the wrong place on the Web page	507
Glossary	509
Quick fix index	521
Index	525

Last Updated: December 12, 2001

Top of Page