PC Help File
Microsoft Office Help

 


Problem:
Measures taken / Solution
 Microsoft OFFICE
You want to change how MS Word, Excel, etc. starts up, saves files, etc.

 

  1. From the menu ribbon at the top of Word - click on Tools, then click on Options. You will get a screen with different tabs to select different option on how Word runs.
  2. Adjust the settings to your preferences and click on the OK button.
MS Excel is giving you the wrong numbers when you are using the sum function to perform calculations on multiple cells - Or you receive a "Circular Reference error"
  1. Excel may be trying to perform a math function on cells that it can not read correctly - Check to see (in the status line at top of sheet) that all the cells are correctly identified.
  2. Use ( ) to separate certain sections of the formula to see where your problem is and try adding the cells 1 at a time.
  3. When you see the colon mark (a1:a15) it means it is performing math on all the cells between those 2 location (including the defined cells)
  4. Use the trace function to locate the offending cell (s)
When you enter text and/or numbers into a cell in MS Excel - the numbers are changed to a different style than what you intended
  1. Click on Format - Cell
  2. Make sure that the cell is formatted to "TEXT" since Excel will take some character to mean that you want the cell to perform some mathematics operation on that particular ( i.e. a small e to Excel mean treat this number in an exponential form)
You want to change the icons on your button bars.
  1. Right click on one of the existing button bars
  2. Left Click on Customize
  3. Left Click on the button you want to customize
  4. Right Click on the button
  5. Click on Edit Button Image
  6. Redraw your button to your needs.
Your button bar for MS Office no longer starts when you start Windows
  1. Open the Program Group MS Office
  2. Open the Program Group Start Up (If you do not have a group "Start Up" you can create one by clicking on File New in Program Manager, and choosing new group (Name it Start Up)
  3. While holding down the Ctrl key click on the Icon called MS Office inside your MS Office group and drag a copy of the Icon to your Start Up Group.
  4. If you do not have MS Office on your hard drive you will not have the button bar available to you since the button bar does not reside on the network versions of MS Office.
When you try to save your file to the floppy disk you are using you get an error saying that Word (or Excel, WP, Access, etc.) can not save or create this file.
  1. This usually means the disk is write protected 
  2. Remove the disk
  3. Slide the little tab on top of the disk down (so you can NOT see through the little hole in the top of the disk.
  4. If the little tab is missing, or broken, you can use a piece of tape to cover the hole so the computer can save the file (But it is better to use another disk)
  5. Use a new formatted disk.
One of the button bars that you normally use no longer show on screen

 

  1. Right click on one of the existing bars 
  2. Left click on the button bar you are missing OR
  3. Click on View
  4. Click on Toolbars
  5. Check the box of the bars you want to see
You want to change where your Office button bar appears along the top of the screen when you use the small buttons.
  1. Open the c:\windows\msoffice.ini file using either edit or notepad.
  2. Change the line rightpos=## to where you want the right most button to appear. Note: the number will refer to the number of pixels from the very right-hand edge the bar will start. This is determined by your screen resolution: ex. if you use a 600X400 screen resolution then there are 600 poxels (dots) across your screen.
You want to remove duplicate files from an Access database in order to set up key fields.
  1. There are several ways - one of the easiest is to... 
  2. Export the structure of the current table to a holding data base
  3. Import that structure back into your database
  4. Open design and set a key field to "Index no duplicates" (setting the field will automatically enforce this)
  5. Go to the data table and from the menu select Edit, Select all records, Copy
  6. Go the the new table and Paste Append. (This will only allow records into the new table that are not duplicates)
MS Access locks up after a large cut (or copy) and paste operation.

 

  1. First give your PC time to write any errors to a new data base
  2. If it still locks up use the ctrl+alt+del keys to shut down Access
  3. Exit to DOS and check your temp file for any ~*.tmp files and delete them (delete all the temp files) 
  4. Restart Windows
Printer not responding to a print job (or you get that error message - Printer not responding.)
  1. The printer can be controlled in several ways (besides in the application program), Use either the Print Manager Icon inside the group main or the Printers Icon inside the Control Panel program.
  2. Check to see that the printer is turned on, on-line, and not jammed with paper.
  3. If printer has a test print function - test it, then use the print manager to make sure you are connected to a port (Usually LPT1)
MS Word, Excel, Access, Publisher, 
Power Point

running very slowly & locking up 

  1. Defragment Hard Disk - Run MS DOS program " Defrag c: /f ".
  2. Run MS DOS program " Scandisk ".
  3. Set Windows swap file for virtual memory to at least 4 Mb / per 8Mb of physical RAM.
  4. Remove wallpaper and extra fonts from Windows start-up files - From the "Control Panel" program located in the Group "Main".
  5. Close other programs that are open (Remember to save files first).
  6. From the menu ribbon: Click View - click Normal (page layout view requires more memory to run)
  7. From the Tools - Option menus [ Save tab ] turn off the Automatic Save, Allow Fast Save Options.
  8. From the Tools - Option menus [ View tab ] turn off the Status bar, and Scroll Bar Options.
  9. From the Tools - Option menus [ General tab ] turn off the background repagination, 3D Dialog and Display Effects, and Help for Word Perfect users, and Update Automatic Links at Open Options.
  10. From the Tools - Option menus [ General tab ] Reduce the number of Recently Used File List to 2 or 3
  11. Click on View Toolbars ... and Close the un-needed toolbars, and turn of the Color buttons.
  12. Delete all temporary files in the c:\temp directory (Exit Windows first)
When you try to type in your Word documents (also with other word processors such as WordPerfect) the computer types over what you currently have written.
  1. Tap the insert key. This will toggle your typing method from inserting text to typing over text.
Office products locking up when you start or Exit 

Note: using ctrl+alt+delete will often allow you to shut down the application that is not responding.

  1. Make sure that you do not have an excessive amount of temp files built up (from the directory c:\temp> type del *.* )
  2. Run Scandisk and defrag utilities
  3. If you are trying to access the network versions of these program some times you can use the optional executable files to launch the program (although this is not the recommended method)
  4. For example in the file properties box of MS Word, instead of running the winword.exe file try running the _winword.exe file.
  5. If this seems to remedy your problem then you should probablly delete your reg.dat file and reinstall the network workstations.
  6. If you have other applications running, try shutting down all the other apps. and restarting Word.
  7. Try increasing your Windows swap file to at least 6Mb.
You want to insert the Ashland logo (any art) into one of your documents

(inserting a frame first then inserting the pict. into the frame makes it easier to move)

  1. Click on insert - and choose picture
  2. using the choice buttons go to drive J: \ userdata \ art
  3. pick one of the ashland logo’s and choose ok
  4. Note: files with a bmp ending will not appear as smooth as those with the cgm ending.
  5. You call also use the "Insert" - "Object" - and choose the Clipart Gallery option. This will give you artwork that has already been installed in the gallery database, so you won’t need to know the location or path. (However if you haven’t updated new art to it .. this will not automatically look for it)
You can not insert Excel sheets and charts into Word, (Getting GPF error messages, dynalink faults etc.) May have had errant program  installed onto your PC 

 

 

 

 

 

 

 

 

 

 

 

 

 

  1. There have been some major difficulties found when xxx is installed onto the PC's. This applies even if you have only had a workstation installation performed. 
  2. Often the files that are corrupted or missing are the ones listed below:
  1. compobj.dll
  2. ctl3d.dll
  3. ole2.dll
  4. ole2prox.dll
  5. olecli.dll
  6. qelib.dll
  7. qeutil.dll
  8. scp.dll
Along with the above files 8888 can mis-report the following files:
  1. ole2conv.dll, 
  2. ole2displdll, 
  3. ole2nls.dll, 
  4. storeage.dll 
Copy original versions of these files to you windows / system directory
You want to add a new sheet to your Excel workbook.
  1. Using the RIGHT mouse button click on one of the tabs at the bottom of your work book
  2. Click on Insert
  3. Click on worksheet
You want to give the worksheet in your Excel workbook a different name other than sheet1, sheet2, etc.
  1. Click on the sheet you want to rename
  2. Using the RIGHT mouse button click on the tab of the sheet
  3. Pick rename from the menu
  4. Note: you can NOT use blank spaces in the name (try the underscore "_" or the dash"-")
You want to change the order that the sheets appear in Excel
  1. RIGHT click the sheet you want to move
  2. choose move from the little popup menu
  3. scroll down the selection box and choose your spot.
You want to change the color of the tabs in MS Escel (up to ver. 5.0)
  1. YOU CAN’T
  2. Buy Quatro Pro (Currently owned by Corel and Word Perfect)
You want to copy information from the cell(s) on one sheet to another sheet so that when you change the information on the original it updates the second sheet.
  1. Highlight the information you want to copy and click the copy button or the Edit, Copy menu item.
  2. Go to the sheet and area you want to paste the information into
  3. Click the menu items - Edit
  4. Cilick Paste Special
  5. When the box appears click on the Paste Link button. 
In "Excel" You want to copy information from one workbook or file to a different file.
  1. Use the same procedure as above; However, you must have both files or workbooks open at the same time.
  2. You can also use this procedure to move or copy entire sheets from one workbook to another.
You want to make your own button bar

 

 

 

  1. Right click on any existing open button bar and choose Toolbars...
  2. Click on new and give it a name (like my bar) and click ok
  3. You will then be at a customize box to add your own buttons !!
You want to be able to access the files in Word, Access, and Excel that you have most recently used.

 

 

 

  1. You can choose how many files Word, Excel, etc. remembers by clicking on tools, then clicking on options.
  2. Next click on the tab marked General
  3. Make sure there is an X in the box marked recently used file list. (clicking on the box toggles the check - un-check)
  4. Use the arrow keys to pick the number of files you want to remember.
  5. When you start the program the next time it will start remembering what files you had open.
  6. Click on file and you will see a list of your files, just click on the file you want to open.
You want to use the "Quick Keys" to move around in Word - but everytime you try you get a Word Perfect box of commands.

(Like Alt+F4 to close Word)

 

  1. You have the "Word Perfect help options turned on.
  2. First click on the Tools menu
  3. Choose the Options selections
  4. Click on the General Tab
  5. make sure the Box marked Word Perfect box does not have an "X" in it (clicking on it will check / and uncheck it)
You are changing from Word Perfect to Word and WANT the help to pop up for the old key strokes

 

 

  1. "See Above"
  2. Click on the Tools menu
  3. Click on the Options menu
  4. Click on the General Tab
  5. Make sure that the box marked "Word Perfect Help" has an "X" in it by clicking on the box.
You want to change your rows to columns and your columns to rows (invert) in Excel
  1. First highlight the section you want to switch
  2. Second choose the "Copy" option from the Edit menu
  3. Now find a blank area on your spread sheet and choose the cell you want to be the top left area of that data
  4. Then choose "Paste Special" from the Edit menu
  5. Next, check the box marked "Transpose"
  6. Now you can delete the rows or columns that are not needed, or use the "Cut" and "Paste" options as you normally would.
You want to save a description of the file you are working on, note who wrote it, when it was last edited etc.
  1. Click on File
  2. Click on Summary Info
  3. Put in the information you want to save
You are getting Database errors when you try to open a file in MS Access

 

 

  1. There are two steps you can attempt to fix a database in Access
  2. Start Access, DO NOT OPEN ANY DATABASE (FILES)
  3. Click on File
  4. Click on Repair Database (and in the file box choose the one you are having errors with)
  5. the Second step you can take, is to compact the data, Click on File
  6. Click on Compact Database
  7. Choose the database you want to work with
  8. Give it a name (different from the original)
  9. Click OK
When working with MS Publisher Files you want to see a quick preview of the file before you open it.

 

  1. Open the file
  2. Click on File
  3. Click on Save As
  4. make sure there is a check mark in the box marked "Save Preview"
  5. Click on OK to start save, and OK to overwrite existing file.

Excel, Access, MS Word, Power Point, MS Publisher, Windows are all copywrite, protected and established tradmarks; and subject to all laws of ownership to the Microsoft Corporation.
File by: Charles H. Davis
All Rights Reserved 1998