Microsoft KB Archive/163934

= XL97: "Cannot Find the Mainxl.hlp File" When Using Help =

Article ID: 163934

Article Last Modified on 10/20/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q163934



SYMPTOMS
In the Microsoft Visual Basic Editor, when you attempt to display Help topics for worksheet functions, the following message may appear:

Cannot find the Mainxl.hlp file. Do you want to find this file yourself?



CAUSE
This problem occurs because this section of the Help file points to a Help file for an earlier version of Microsoft Excel. The Mainxl.hlp file, which is used in earlier versions of Microsoft Excel, may not be installed on the computer on which you installed Microsoft Excel 97.



WORKAROUND
To work around this problem, use either of the following methods.

Method 1: Point Microsoft Excel to the Correct Help File
To point Microsoft Excel to the correct Help file, use the following steps:
 * 1) When the error message occurs, click Yes.

The Open dialog box appears.
 * 1) Locate and select the Xlmain8.hlp file and click Open.

The Xlmain8.hlp file is located in the Program Files\Microsoft Office\Office folder. Note that this path is different if you changed the default installation folder for Office when you installed it.

NOTE: For each time you want to display the worksheet function Help topic you must point Microsoft Excel to the correct file.

Method 2: Copy the Correct Help File and Rename It
To copy the Xlmain8.hlp file and rename it to Mainxl.hlp, use the following steps:  In Microsoft Windows Explorer, open the following folder:

C:\Program Files\Microsoft Office\Office

 Click the file named Xlmain8.hlp and click Copy on the Edit menu. On the Edit menu, click Paste. Click the file named "Copy of Xlmain8.hlp." On the File menu, click Rename, and then rename the file to Mainxl.hlp.

Additional query words: 97 jump context sensitive help hyperlink

Keywords: KB163934

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.