Microsoft KB Archive/98064

{|
 * width="100%"|

Excel: Can't Run Tutorial from Network Drive

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
 * Microsoft Windows operating system version 3.1

-

SUMMARY
If you are running Microsoft Excel from a network drive, and you attempt to run the Microsoft Excel tutorial (also called Computer Based Training or CBT), you may experience one of the following problems:

 If you are using Microsoft Excel version 5.0, you may receive one of the following error messages:

EXCELCBT not found

-or-

The path in your EXCEL5.INI file does not include the directory that contains the CBT files. Edit the EXCEL5.INI file by typing the path of the CBT directory on the CBTLOCATION=line under [Microsoft Excel].  If you are using Microsoft Excel version 4.0 or 4.0a, you may receive the following error message:

Cannot run tutorial. There may be another instance of tutorial active.

 If you are using Microsoft Excel version 3.0, the tutorial may fail without any error message.

This problem will occur if you connected to a network resource using the universal naming convention (UNC) rather than by specifying a drive letter. For example, if the command line in the File Properties box for your Microsoft Excel icon is,

server\sharename\netdir\EXCEL.EXE (UNC)

rather than,

G:\netdir\EXCEL.EXE

the tutorial fails in Microsoft Excel versions 3.0 and 4.0 and you may receive one of the error messages listed above if you are running Microsoft Excel version 4.0 or 5.0.

MORE INFORMATION
In Microsoft Windows operating system version 3.1, you can use UNCs for entries in Program Item Properties, Program Group Properties, PIF command lines, and File Manager. UNCs allow you to use a network resource without formally connecting to it (you can do this by typing the MS-DOS &quot;NET USE&quot; command).

The Microsoft Excel tutorial does not currently support the use of UNCs. This problem also occurs with other tutorial programs, such as the Microsoft Word for Windows tutorial.

Workaround
To work around this problem, follow the procedure appropriate for your version of Microsoft Excel:

  If you are using Microsoft Excel version 4.0a or 5.0:

- Set the CBTLOCATION= switch in the EXCEL4.INI (version 4.0a) or the

EXCEL5.INI (version 5.0) file to a specific drive letter. For example, if your Program Item Properties reads

servername\sharename\exceldir\EXCEL.EXE

add the following line to the [Microsoft Excel] section of your EXCEL4.INI or EXCEL5.INI:

CBTLOCATION=G:\exceldir

Note: The drive letter you specify must be the one that your workstation is connected to and CBTLOCATION must be in all capital letters for the setting to work.

This method allows you to continue to use the UNC in the Program Item Properties for the Microsoft Excel icon.

If you are using Microsoft Excel version 3.0, 4.0, 4.0a, or 5.0:

- Connect to the network drive where Microsoft Excel is located and use that drive letter on the command line in the Program Item Properties for the Microsoft Excel icon. For example:

G:\netdir\EXCEL.EXE

Microsoft is researching this problem and will post new information here as it becomes available.

Additional query words: 4.00a

Keywords :

Version : 3.00 4.00 4.00a 5.00

Platform : WINDOWS

Issue type :

Technology :