If the dropdown
boxes on the HR forms do not work correctly you will need to make adjustments
to the settings on your computer. These changes will force Internet Explorer
to open specified MS Office document types to be opened and run in the appropriate
MS Office aEpplication. For example, linking to an Excel file from the HR Forms
Web Page will open xcel to display the form instead of opening it in Internet
Explorer. When the HR Excel forms are opened in Excel the drop down boxes are
activated and provide easy data access with the "first letter search" option.
Based on
the operating system that is running, you will need to do one of the following:
WINDOWS
NT:
NOTE:
This fix must be performed when logged into the workstation on an account that
has Administrator rights. Download the excelfix.reg file and then double click
on it to run it. An alternate method of running this file is to follow the link
to excelfix.reg. When prompted, select "Open this file from its current location".
This will run the file and will make the necessary changes to the Windows Registry.
The result of this fix is that whenever an Excel file is opened through Internet
Explorer, the file will be opened in Excel in a separate window. It will not
be embedded in Internet Explorer.
WINDOWS
95 and WINDOWS 98:
1. Select My
Computer.
2. Select the View menu.
3. Select Options or Folder Options.
4. Select the File Types tab.
5. In the Registered file types list, select the specific Office document
type, in this case select, by clicking on the file type to highlight it: Microsoft
Excel Worksheet.
6. Select Edit.
7. In the Edit File Type dialog box, select OPEN.
8. Perform one of the following steps, depending on the version of Internet
Explorer that is running:
- If you are
running Internet Explorer 3.01, 3.02, or 3.02a: click to clear (unclick) the
Open Web documents in place check box.
- NOTE: The Open
Web documents in place check box is not available if you are running Internet
Explorer version 3.0. If you are running Internet Explorer 3.0, upgrade to
Internet Explorer 3.02 or later.
- If you are running
Internet Explorer 4.0, 4.01, or 5: click to clear (unclick) the Browse in
same window check box.
9. Select OK.
10. Select OK.
WINDOWS
2000:
1. Select My
Computer.
2. Select the Tools menu.
3. Select Folder Options.
4. Select the File Types tab.
5. In the Registered file types list, select the specific Office document
type, in this case select, by clicking on the file type to highlight it: Microsoft
Excel Worksheet.
6. Select Advanced.
7. In the Edit File Type dialog box, select OPEN.
8. Click to clear (unclick) the Browse in same window check box.
9. Select OK.
10. Select CLOSE.
WORK-AROUND:
If the workstation configuration
is such that the above listed fixes cannot be applied, utilize the following
method for working with the HR Excel Forms containing dropdown boxes.
1. Visit the HR
FormsWeb site.
2. Open the specified Excel form.
3. Save the form to the local computer.
4. Close the form in Internet Explorer.
5. Open the locally saved form in Excel.
Source: "Office
Documents Open in Internet Explorer". For a full explanation, visit the Microsoft
web site at:
http://support.microsoft.com/support/kb/articles/Q162/0/59.asp
