University of Wisconsin-Milwaukee Home UWM Libraries

Glory Banner

UWM Libraries, Library Systems Dept
Autofaq (Automation Frequently Asked Questions)

Quick Index
Email / Campus Alphas
(on a separate web page)

Alpha/ePanther mail
Mozilla Thunderbird
Netscape Messenger 7.0
Reflectors
Campus Mail
Information about 'Phishing'
Information relating to the Alphas, not only e-mail

Desktop (LAN) help
Desktop shortcuts
Address Book on desktop
Files
MS file default locations
Word AutoCorrect function
Auto Help icon


  LAN Application help -- Office
Where to find Tips and Tricks

  LAN Application help -- Excel
Save a new file
Save an existing file
Save automatically as you work
Save to a new file name
Sort an Excel file
Quick edit an Excel cell

LAN Application help -- Word
Page X of Y doesn't work in MS Word


OCLC System Alerts
Viruses, Hoaxes
Virus Checking
Where to check about Viruses/Hoaxes

Phishing, E-mail Scams
can be found the the e-mail autofaq page
Hints and Tips
Helpful ideas and hints that may be of use to you.


Desktop (LAN) help . . .


shortcut instructions

from Windows NT help screen
3 March 2000


Can I get a little more information about files, their locations, and where to save them?
  F:\dept\public\
  Files stored in f:\dept\public and its subdirectories are open to ALL users of the Library LAN. These files can be read, modified and completely erased by any single user on the system. If you have placed files in that subdirectory thinking that they are private or safe from deletion, please move them to your own user directory (g:\) or to departmental space that you share.
  Mail attachments, saving as a file
  Attachments to mail messages are stored with mail in a message database maintained by the GroupWise system, not as documents. If you receive a file from a colleague as an attachment, altering it without saving it to your own space first can have very confusing consequences. When you need to alter a file you've received as an attachment, you should first save that file in your own network space. At that point, you can use the appropriate application (Word, Excel, WordPerfect, etc.) to open it and alter it. If you are collaborating with a departmental person, consider storing th draft document in your shared department directory (f:\dept\�) rather than sending it as an attachment.
. . . .
lmp@uwm.edu
25 October 2000


Your files may not be where you think they are!

Microsoft Office
Word
Excel
Access
PowerPoint
. . . . We have recently discovered that many of our users are unknowingly saving files they've worked on to the c: drive (space that shows up with directory name Personal when you save) rather than to network space where they would get backed up regularly.

The Microsoft Office products (Word, Excel, Access, PowerPoint) come with settings that assume you are using a local "personal" directory. This is fine for home use or non-networked office use, but in our environment, the better place to set the default is the network.

To check on this and/or reset it in each product, please do the following:

MS Word:

Tools
Options
File Locations
Highlight the item listed Documents
Modify
Change directory to g:\ (or some other subdirectory of g: if you prefer)
OK
OK


MS Excel:

Tools
Options
General
Default File Location Box should read g:\ (or some other subdirectory of g: if you prefer)


MS Access:

WITH A DATABASE OPEN
Tools
Options
General
Default Database Folder should read g:\ (or some other subdirectory of g: if you prefer)


MS PowerPoint:

Tools
Options
Advanced
File locations
Default file location should read g:\ (or some other subdirectory of g: if you prefer)


If you've been saving files to the Personal c: space and want to move them all over to your network space please e-mail us (#auto) and we'll be happy to help you out.



lmp@uwm.edu
25 October 2000


Word is changing my typing.
how do I stop it from doing this?
. . . . A sometimes annoying feature of Microsoft Word is AutoCorrect, which will automatically 'correct' items as you type. Some features can be rather bothersome; here is how to eliminate the problem ones.

In Word:

Select Tools,
select AutoCorrect,
click on the AutoCorrect tab
uncheck the boxes to stop ALL autocorrect features,
OR
you can scroll through the list and remove (Delete) the entries that are causing you problems

This will stop AutoCorrect from replacing selected or ALL characters.

dbabin@uwm.edu
12 December 2000


Where can I find the Automation Help icon?
. . . . If your Automation Help icon doesn't show on your desktop, it may be hiding behind other icons. Try dragging some of your other icons a bit on the screen and see if its hiding anywhere.

lmp@uwm.edu
25 October 2000

Viruses, Virus Scanning, and Hoaxes . . .


With all of the news stories about viruses and warnings, how can I check that I have the most current virus checking?
. . . . To check on the currency of your information:

Right click (or opposite if you've set your mouse to be left handed) on the V shield in the lower right hand corner of your desktop. Using the "normal" mouse button, click on Console, Help, About. The Created on: date should be within the last 2 weeks, depending on when in the week your machine is set to update. Click OK to get out of this box. If your Virus definitions are new enough, just exit this utility using the X in the upper right corner.

If the Virus definitions in your machine are older than this, it should be updated NOW:

Double click on Automatic DAT Update (this is the MIDDLE choice on the Console). The Transfer Method selected should be FTP from a remote network computer. Click on Schedule. Check off Enable scheduler, Fill in the dot for Weekly, put in a time and day that will occur when you ARE LOGGED IN during the work day. For this updating to work correctly, you need to have your machine turned on and be logged in during the scheduled time. No accommodation for vacation or sick days is necessary since this process will attempt to run every week. Being only one or two weeks behind in virus definitions is not a critical problem.
Click OK to set this.

To get up to date right now, click on Update now and wait for the process to finish. This is the same process that will attempt to run during the above scheduled time. Click OK to exit the utility.

Network Associates continually adds to the base of viruses that the VirusScan software checks for. It is good to keep fairly up to date on these.

Thanks and please call Automation if you need assistance.


lmp@uwm.edu
20 December 1999


Where can I check on Virus Warnings being Hoaxes?
. . . . Several listings of sources of information on hoaxes are available on the Web:

HoaxBusters (Department of Energy Computer Incident Advisory Capability) at
http://HoaxBusters.ciac.org/

Symantec Anti Virus Research Center at
http://www.symantec.com/avcenter/index.html

McAfee Associates Virus Hoax List at
http://vil.mcafee.com/hoax.asp

Dr. Solomon's Hoax Page at
http://www.drsolomons.com/vircen/vanalyse/va005.html

The Urban Legends Archive at
http://www.urbanlegends.com

Urban Legends Reference Pages at
http://www.snopes.com

Datafellows Hoax Warnings at
http://www.Europe.Datafellows.com/news/hoax.htm

Information on Pop-up virus warnings at
http://www.willswebs.com/popup.html

As is always the case, if you cannot verify that something is a Hoax, feel free to forward the warning to Automation, where a complete review can be made. Do not forward such a message to the entire staff, as this will simply interfere with the ability of Automation to check out the matter.


LAN Application help . . . Microsoft Office (emphasis on Excel)


Where can I look for Tips relating to Office 2000?
. . . .

Two good locations to find Tips, Articles and Tricks for Office 2000:

Microsoft Assistance Center, Office 2000 Articles and Tips
     http://office.microsoft.com/assistance/2000.aspx

Office 2000 Tips andTricks archives
     http://www.microsoft.com/office/previous/tips

Source: Microsoft web site.
14 March 2003

 


How do I save a new file?
. . . . To SAVE a new, unnamed file:
  1. On the File menu, click Save As.
  2. In the Save in list, select the drive and folder where you want to save the file.
    To save the file to a new folder, click Create New Folder.
  3. In the File name box, type a name for the file.
  4. Click Save.
Source: Microsoft Excel help.
14 December 2001


How do I save an existing file?
. . . . To SAVE an existing file:
  1. On the File menu, click Save.

Source: Microsoft Excel help.
14 December 2001


How do I save automatically as I am working?
. . . . To change settings so that the system saves automatically as you work:
  1. On the Tools menu, click AutoSave. If the AutoSave command is not available on the Tools menu, please call Automation (-3999) to have the AutoSave add-in installed.
  2. Selelct the Automatic save every cehck box.
  3. In the Minutes box, enter how ofter you want Microsoft Excel to save you file.
  4. Select any other options you want.
Source: Microsoft Excel help.
14 December 2001


How do I save an existing file with a new file name?
. . . . To SAVE an existing file with a new name:
  1. Open or have open the file you want to save with a different name.
  2. On the File menu, click Save As.
  3. In the File name box, type a new name for the file.
  4. Click Save.
Source: Microsoft Excel help.
14 December 2001


How do I sort an Excel file?
. . . . To SORT an Excel file:
  1. Click on the cell in the file that you want to sort by.
  2. On the Data menu, click Sort.
  3. In the Sort by and Then by boxes, click the columns you want to sort.

    If you need to sort by more than three columns, sort by the least important columns first. For example, if your list contains employee information and you need to organize it by Dept., Title, Last Name, and First Name, sort the list twice. First click First Name in the Sort by box and sort the list. Second, click Deptin the Sort by box, click Title in the first Then by box, and click Last Name in the second Then by box, and sort the list.
  4. Select any other sort options you want, and then click OK.
Source: Microsoft Excel help.
14 December 2001
How can I quick edit an Excel cell-without using the Mouse?
. . . .

You can quick edit in a Excel spreadsheet without moving your hands from the keyboard to the mouse, then back to the keyboard.

Here's what you do:

  1. Using the arrow keys, arrow to the cell you want to edit (normally this would require a double-click of the Mouse).
  2. Press the F2 key.
  3. Edit the contents as you normally would.
  4. When finished editing, press ENTER to make the changes, or ESC to cancel the changes.

    Note: This is particularly useful for editing hyperlinks in Excel, as a mouse-click will open your Internet browser. Using the keyboard eliminates this problem.
Source: UAB Excel help. [More tips and tricks at: http://www.hrm.uab.edu/Training&Development/tipsexcel.html]
13 March 2003

LAN Application help . . . Microsoft Office (emphasis on Word)

Page X of Y doesn't work in Microsoft Word

This is a known problem. There is a web page specifically to explain more about this. It is located at:

http://www.addbalance.com/word/pagexofy.htm

26 June 2003



OCLC System Alerts

With the recent problems with OCLC services, including Connexion cataloging, it's a good time to remind everyone that any of us can at any time check the *OCLC system alerts page *at*    http://www.oclc.org/support/systemalerts/*

They keep it updated pretty regularly if there are problems, and you can check it to see whether a problem is something at the OCLC end that they are aware of and working on. Not a bad idea to even bookmark this page and check it out when you're having problems with an OCLC product.
It's more up to date and reliable than waiting for messages from WiLS, and after the services go up and down again several times within a day, WiLS ends up pointing users to this page anyway.


Steve Miller
27 May 2005