Help Desk – XP and Office 2007
A repository for troubleshooting responses to some common Windows XP, Office 2007 Help Desk calls.
- Windows XP
- Word 2007
- Excel 2007
- PowerPoint 2007
- MacPac 10
- DM
- GroupWise 7
- Firefox
- Internet Explorer 7
- Novell
- Adobe Reader 9
- Winzip
- Paint
- Citrix
Windows XP
How to change the screen resolution
To change the screen resolution, right click anywhere on the desktop and select Properties. In the Display Properties window, click on the Settings tab. Move the Screen Resolution slider to the desired resolution (1024 by 768 pixels is common). Click Apply to test the changes. If the new resolution is acceptable, click Yes in the new Monitor Settings window to save the settings. Click OK to exit.
Word 2007
How to re-enable a 'hard-disabled' add-in
Click the Office Button, then click Word Options (Alt+F, I).
Click the Add-Ins tab and scroll to the bottom of the Add-ins list. Note the name of the disabled add-in.
Select Disabled Items from the Manage menu and click Go.
Click the item you wish to re-enable, and click Enable. Click Close.
How to reload a 'soft-disabled' add-in
Click the Office Button, then click Word Options (Alt+F, I).
Select COM Add-ins from the Manage menu and click Go.
Place a check in the box next to each add-in you wish to reload and then click OK.
The functionality should be available immediately.
How to turn off Track Changes notification
Click on the Office Button -> Word Options (Alt+F, I)
Click on the Trust Center along the left pane
Click on the Trust Center Settings button
Click on Privacy Options along the left pane
Under the "Document specific settings" area, uncheck the first option, "Warn before printing, saving or sending a file that contains tracked changes or comments".
How to accept Track Changes
Click the Review tab, and in the Changes group, click Accept -> Accept All Changes in Document.
How to repeat a table row on each page
Put the cursor in a cell in the row to become a header row and under the VP Table Tools tab, Data group, click Repeat Header Rows. You can also right-click in the table cell and choose Table Properties -> Row tab, and place a checkmark next to "Repeat as header row at the top of each page".
How to toggle table gridlines
Click in the table, and under the VP Table Tools context tab, Table group, click View Gridlines.
(In native Word, this is Table Tools -> Layout -> View Gridlines.)
How to sort tables in Word
Put the cursor anywhere in the table, then click the Table Tools context tab. Click the Sort button in the Data group to open the Sort dialog box. Pick which column to sort on and the desired order.
How to make Word display more information about your document
Word can display useful information about your document in the status bar (at the bottom of the application). Right-click an empty area of the status bar and choose what information you wish to display.
You can choose to display such things as Word Count, current Section, current Page, and Track Changes.
How to sum a column in a Word table
Place the cursor in the table cell that will hold the sum, then click the Table Tools context tab. Click the Formula button in the Data group to open the Formula dialog box.
In the Formula field, type: =SUM(ABOVE)
Click OK.
How to get the style area pane back
Click the Office Button, then click Word Options (Alt+F, I).
Click on Advanced, then scroll down to the Display area.
Enter a value in inches next to "Style area pane width in Draft and Outline views:" (1" is a good starting place.)
Excel 2007
How to copy just the data (not the formulas) to a new sheet while retaining the formatting
This is a two step process.
If you copy everything, then do a Paste Special and choose Data, you lose the formatting.
If you copy everything, then do a Paste Special and choose Formulas, you keep the formatting, but also get the formulas.
The solution is to first to copy the formulas and formating, then convert the formulas to data.
Select all, then copy and paste into the new sheet. Then select everything again and Paste Special -> Values.
How to add leading zeros to a column of zip codes
Select all of the cells in the column, right-click any cell and select Format Cells. Under the Number tab, choose Special, and a Type area will appear. Choose Zip Code as the number type and click OK.
Choosing what to print
Select the fields that contain data you want to print by clicking the bottom-right cell and dragging the selection to the top-left cell and then selecting Page Layout -> Print Area -> Set Print Area.
Choosing how many pages to print (this determines the size of the text)
Once your print area has been set, click on View -> Page Break Preview. To move the page breaks, drag the dashed lines. To create a new break, right-click anywhere in the spreadsheet and select Insert Page Break from the pop up menu.
How to clear all page breaks
There are two ways to clear all of the page breaks in an Excel document:
1. click on Page Layout -> Breaks -> Reset All Page Breaks, or
2. right-click anywhere in the spreadsheet and select Reset All Page Breaks from the pop up menu.
PowerPoint 2007
MacPac 10
Opening Word or clicking on the MacPac10 tab produces an error
MacPac
Error: SessionException
Description: Could not initialize the session.
The details of the error message contain text referencing errors connecting to databases.
The fix is to close Word, delete the file:
C:\Program Files\The Sackett Group\MacPac\Data\mp10Sync.mdb
Open Regedit and navigate to:
HKEY_CURRENT_USER\Software\The Sackett Group\Deca\Sync\
and change the Executing value to 0
Reopen Word.
How up update a trailer in XP/2007
Click on the MacPac 10 tab, then click on the Trailer/Doc ID button in the Document group. Choose a location for the trailer from the options and click OK.
DM
How to check-in documents in DM
Reboot and get the Undocked Documents prompt, then proceed through the prompts.
-or-
Close Word and DM, and any other applications with DM integration, then kill two processes:
DM.exe
Interceptor.exe
Reopen DM from the desktop shortcut to get the Undocked Documents prompt and proceed through the prompts.
-or-
Close Word, right-click the HummingBird DM systray icon and choose Log Off. (... unfinished steps ...)
How to email just a redline attached to a DM document, without a clean version.
Open DM, locate the document, right-click it and select Mail.
In the "Document Mailing Options" window, choose "Select" in the "Versions" drop down menu. The window will expand.
(Note that the Versions tab is active and one of the document's versions has a grey highlight.)
Click the Attachments tab and click the attachment you wish to mail.
Click on the Versions tab. You should see one of the versions is now highlighted with a blue background. Click in the area below the last version. The highlighted version should be deselected.
Click OK to create the email with just the attachment.
GroupWise 7
GroupWise opens and displays a message that a newer version exists
There is new GroupWise software available, however, you cannot currently access the new software to update. Please contact your administrator.
Do you want to continue to receive this update message?
Click No to stop seeing this message.
If the message continues to occur each time GW is opened, increment the value of:
[HKEY_LOCAL_MACHINE\SOFTWARE\Novell\GroupWise\Client\5.0]
"NewSoftwareBump"="1"
How to use the "Save to Hummingbird DM" button in GroupWise
Open the mail message and click the "Save to Hummingbird DM" button.
Uncheck the box next to the envelope.
In the Attachments drop down menu, choose "Save using specific options".
Check the box next to "Save attachments separately".
Click OK.
Check the box next to the attachments that you want to save and uncheck the "Mime" item, which is the mail message itself.
Click OK and complete the profile for each document.
Click Save.
You may need to hit F5 to refresh DM if the documents do not appear.
How do I edit the HTML signature using an external editor?
There is no way to directly edit the HTML code of the signature in GroupWise 7 or to paste source code into the WYSIWYG editor window, but you can still use an external editor (Dreamweaver, Notepad, etc.) to create the signature.
First, create the signature in the external editor and save it as an .html file. Open the file in a browser, so that the HTML is rendered and displays as it should in the email. Then select and copy the rendered HTML and paste it into the signature window in GroupWise.
(The Vedder Price blue is Pantone 8203 C, close to RGB 57,115,145.)
How to disable the splash screen in GroupWise Notify
Opening Notify sometimes causes the splash screen to stick. Ending the notify.exe process removes the splash screen. A more permanent fix is to not display the splash screen at all when Notify starts.
Edit any GroupWise Notify shortcuts to add a /bl switch, e.g.: C:\Novell\GroupWise\notify.exe /bl
How to change the default font size for received HTML messages
In GroupWise 7.x, the default font for printed HTML emails (incoming) is controlled by the "Message Box" font in Windows. The Message Box font can by changed by going to Display Properties -> Appearance -> Advanced -> Item: Message Box. (Tahoma 8 is the default for XP, but Tahoma 10 is a better choice here.)
How to print an HTML email without the [User] - [Subject] header
Right-click an HTML email in a folder and select View, then right-click in the message body area and select Print.
Email prints without the [User] - [Subject] header.
There are many methods for printing emails. Below are some methods and the results.
Open an HTML email and click File -> Print.
Email prints with the [User] - [Subject] header.
Open an HTML email and click the Print toolbar button.
Email prints with the [User] - [Subject] header.
Open an HTML email, right-click in the message body and select Print.
Email prints without the [User] - [Subject] header (but also prints without the From, To, Date, Subject, and Attachments lines).
Right-click an HTML email in a folder and select Print.
Email prints with the [User] - [Subject] header.
Right-click an HTML email in a folder and select View, then click File -> Print.
Email prints with the [User] - [Subject] header (but also prints the From, To, Date, Subject, and Attachments lines twice).
Right-click an HTML email in a folder and select View, then click the Print toolbar button.
Email prints with the [User] - [Subject] header (but also prints the From, To, Date, Subject, and Attachments lines twice).
How to print an HTML email received as an attachment without the [User] - [Subject] header
Open the containing email. Right-click any attachment and select print. Highlight the Embedded Msg(s) that correspond to the attached email(s) you wish to print. (Use Ctrl+Click to select multiple, non-contiguous items.)
Firefox
Firefox fails to open with an error message
Close Firefox
Firefox is already running, but is not responding. To open a new window, you must first close the existing Firefox process, or restart your system.
A look at the processes shows no firefox.exe process running. Restarting the system does not resolve the issue.
There is a 'profiles.ini' file in
C:\Documents and Settings\<username>\Application Data\Mozilla\Firefox
That file contains a line that points to a subfolder in
C:\Documents and Settings\<username>\Application Data\Mozilla\Firefox\Profiles
The subfolder will be named something like 'fi1dzouf.default'. If this *.default folder is missing or if the path is incorrect, the error is generated.
To resolve, delete the *.default folder (if it exists) and profiles.ini file from
C:\Documents and Settings\<username>\Application Data\Mozilla\Firefox
This will reset Firefox to factory default.
(If the user has a roaming profile, it may be possible to retrieve a backup of the *.default folder and profiles.ini from the H: drive. Restoring these backed-up files will preserve any customizations and add-ins.)
Internet Explorer 7
How to clear the remembered form data
The automatically remembered form data can be cleared by clicking Tools -> Internet Options -> Content tab. In the Autocomplete area, click Settings. Choose what to delete and then click OK.
Novell
Adobe Reader 9
How to print comments in Adobe Reader
Click File -> Print, and in the "Comments and Forms" drop down, choose "Document and Markup".
How to print only the top 8.5 x 11 inches of a 8.5 x 14 inch PDF in Adobe Reader
Click File -> Print, and under the Page Handling area, select Page Scaling: None, and uncheck Auto-Rotate and Center.
The preview should have the top portion of the document highlighted.
Winzip
Paint
Citrix
SSL error 61 (the server certificate received is not trusted)
Run Windows Updates and update the root certificates.
SSL error 68 (the SSL certificate is not yet valid)
Set the local system clock to the current date and time.
SSL error 70 (the SSL certificate is no longer valid)
Set the local system clock to the current date and time.
