|
Problem:
|
Measures taken / Solution
|
| Microsoft
OFFICE |
| You want
to change how MS Word, Excel, etc. starts up, saves files, etc.
|
-
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.
-
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" |
-
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.
-
Use ( ) to separate certain sections of
the formula to see where your problem is and try adding the cells 1 at
a time.
-
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)
-
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 |
-
Click on Format - Cell
-
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. |
-
Right click on one of the existing button
bars
-
Left Click on Customize
-
Left Click on the button you want to customize
-
Right Click on the button
-
Click on Edit Button Image
-
Redraw your button to your needs.
|
| Your button
bar for MS Office no longer starts when you start Windows |
-
Open the Program Group MS Office
-
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)
-
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.
-
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. |
-
This usually means the disk is write protected
-
Remove the disk
-
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.
-
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)
-
Use a new formatted disk.
|
| One of the
button bars that you normally use no longer show on screen
|
-
Right click on one of the existing bars
-
Left click on the button bar you are missing
OR
-
Click on View
-
Click on Toolbars
-
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. |
-
Open the c:\windows\msoffice.ini file
using either edit or notepad.
-
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. |
-
There are several ways - one of the easiest
is to...
-
Export the structure of the current table
to a holding data base
-
Import that structure back into your database
-
Open design and set a key field to "Index
no duplicates" (setting the field will automatically enforce this)
-
Go to the data table and from the menu
select Edit, Select all records, Copy
-
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.
|
-
First give your PC time to write any errors
to a new data base
-
If it still locks up use the ctrl+alt+del
keys to shut down Access
-
Exit to DOS and check your temp file for
any ~*.tmp files and delete them (delete all the temp files)
-
Restart Windows
|
| Printer
not responding to a print job (or you get that error message - Printer
not responding.) |
-
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.
-
Check to see that the printer is turned
on, on-line, and not jammed with paper.
-
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 |
-
Defragment Hard
Disk - Run MS DOS program " Defrag c: /f ".
-
Run MS DOS program
" Scandisk ".
-
Set Windows swap
file for virtual memory to at least 4 Mb / per 8Mb of physical RAM.
-
Remove wallpaper and extra fonts from
Windows start-up files - From the "Control Panel" program located in the
Group "Main".
-
Close other programs that are open (Remember
to save files first).
-
From the menu ribbon: Click View
- click Normal (page layout view requires more memory to run)
-
From the Tools - Option
menus [ Save tab ] turn off the Automatic Save, Allow Fast Save Options.
-
From the Tools - Option
menus [ View tab ] turn off the Status bar, and Scroll Bar Options.
-
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.
-
From the Tools - Option
menus [ General tab ] Reduce the number of Recently Used File List to 2
or 3
-
Click on View Toolbars ...
and Close the un-needed toolbars, and turn of the Color buttons.
-
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. |
-
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. |
-
Make sure that you do not have an excessive
amount of temp files built up (from the directory c:\temp> type del
*.* )
-
Run Scandisk and defrag utilities
-
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)
-
For example in the file properties box
of MS Word, instead of running the winword.exe file try running the _winword.exe
file.
-
If this seems to
remedy your problem then you should probablly delete your reg.dat file
and reinstall the network workstations.
-
If you have other applications running,
try shutting down all the other apps. and restarting Word.
-
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) |
-
Click on insert - and choose picture
-
using the choice buttons go to drive J:
\ userdata \ art
-
pick one of the ashland logo’s and choose
ok
-
Note: files with a bmp ending will not
appear as smooth as those with the cgm ending.
-
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
|
-
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.
-
Often the files
that are corrupted or missing are the ones listed below:
-
compobj.dll
-
ctl3d.dll
-
ole2.dll
-
ole2prox.dll
-
olecli.dll
-
qelib.dll
-
qeutil.dll
-
scp.dll
Along with the above files
8888 can mis-report the following files:
-
ole2conv.dll,
-
ole2displdll,
-
ole2nls.dll,
-
storeage.dll
Copy original
versions of these files to you windows / system directory. |
| You want
to add a new sheet to your Excel workbook. |
-
Using the RIGHT mouse button click on
one of the tabs at the bottom of your work book
-
Click on Insert
-
Click on worksheet
|
| You want
to give the worksheet in your Excel workbook a different name other than
sheet1, sheet2, etc. |
-
Click on the sheet you want to rename
-
Using the RIGHT mouse button click on
the tab of the sheet
-
Pick rename from the menu
-
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 |
-
RIGHT click the sheet you want to move
-
choose move from the little popup menu
-
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) |
-
YOU CAN’T
-
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. |
-
Highlight the information you want to
copy and click the copy button or the Edit, Copy menu item.
-
Go to the sheet and area you want to paste
the information into
-
Click the menu items - Edit
-
Cilick Paste Special
-
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. |
-
Use the same procedure as above; However,
you must have both files or workbooks open at the same time.
-
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
|
-
Right click on any existing open button
bar and choose Toolbars...
-
Click on new and give it a name (like
my bar) and click ok
-
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.
|
-
You can choose how many files Word, Excel,
etc. remembers by clicking on tools, then clicking on options.
-
Next click on the tab marked General
-
Make sure there is an X in the box marked
recently used file list. (clicking on the box toggles the check - un-check)
-
Use the arrow keys to pick the number
of files you want to remember.
-
When you start the program the next time
it will start remembering what files you had open.
-
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)
|
-
You have the "Word Perfect help options
turned on.
-
First click on the Tools menu
-
Choose the Options selections
-
Click on the General Tab
-
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
|
-
"See Above"
-
Click on the Tools menu
-
Click on the Options menu
-
Click on the General Tab
-
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 |
-
First highlight the section you want to
switch
-
Second choose the "Copy" option from the
Edit menu
-
Now find a blank area on your spread sheet
and choose the cell you want to be the top left area of that data
-
Then choose "Paste Special" from the Edit
menu
-
Next, check the box marked "Transpose"
-
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. |
-
Click on File
-
Click on Summary Info
-
Put in the information you want to save
|
| You are
getting Database errors when you try to open a file in MS Access
|
-
There are two steps you can attempt to
fix a database in Access
-
Start Access, DO NOT OPEN ANY DATABASE
(FILES)
-
Click on File
-
Click on Repair Database (and in the file
box choose the one you are having errors with)
-
the Second step you can take, is to compact
the data, Click on File
-
Click on Compact Database
-
Choose the database you want to work with
-
Give it a name (different from the original)
-
Click OK
|
| When working
with MS Publisher Files you want to see a quick preview of the file before
you open it.
|
-
Open the file
-
Click on File
-
Click on Save As
-
make sure there is a check mark in the
box marked "Save Preview"
-
Click on OK to start save, and OK to overwrite
existing file.
|