Excel: Can't Run Tutorial from Network Drive

ID: Q98064


The information in this article applies to:


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:

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 "NET USE" 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        : 

Last Reviewed: April 2, 1999