• Microsoft Excel for Windows, version 5.0
• Microsoft Windows 3.1
• IBM OS/2 versions 2.0, 2.1

SUMMARY

When you install Microsoft Excel version 5.0 under the OS/2 operating system, the Microsoft Excel Setup program will not install the CBT (computer based training) or tutorial.

CAUSE

Specific components of the CBT involve automated cursor movements and special window effects. These functions will operate correctly under the Windows operating environment, but cannot be guaranteed to operate correctly in the IBM OS/2. Therefore, the Microsoft Excel version 5.0 Setup program detects the operating environment, and will only install the CBT under Microsoft Windows.

WORKAROUND

To install the CBT files, you can decompress them from the Microsoft Excel version 5.0 disks to an EXCELCBT directory.

Once the CBT files are installed, you can run it in a full screen session of OS/2 (you cannot, however, run it in an OS/2 window).

For more information about how to run and install the CBT files under OS/2, see the "More Information" section of this article below.

MORE INFORMATION

The CBT can be run under IBM OS/2 while Microsoft Excel version 5.0 is running in a full-screen WIN-OS/2 session. If you attempt to run the CBT in a WIN-OS/2 window the CBT may fail and cause the machine to hang.

To configure Microsoft Excel version 5.0 to run as a full screen application, follow these steps:

1. In the OS/2 Desktop, locate the Microsoft Excel version 5.0 for Windows icon.



2. With the mouse pointer on the Microsoft Excel version 5.0 icon, press the right mouse button to display the pop-menu for the icon.



3. From the menu, click the arrow directly to the right of the Open option, and then choose Settings.



4. Select the Session tab to display the session options.



5. Select the WIN-OS/2 Full Screen option.



6. Close the Settings window by double-clicking the Close button in the upper-left corner of the Settings window.

1. At the MS-DOS or OS/2 prompt, change to the EXCEL program directory. For example, type:

   c:
   cd\excel




2. Use the MS-DOS MD command to create a directory called EXCELCBT. For example, type:

   md excelcbt




3. Insert the Microsoft Excel version 5.0 Setup Disk 1 into your computer's floppy disk drive (in the steps below, this is drive A).



4. Copy DECOMP.EXE to the EXCEL program directory. For example, type:

   copy a:\decomp.exe c:\excel




5. Make sure the Microsoft Excel version 5.0 Setup Disk 1 is still in drive A.



6. Type the following MS-DOS commands

   decomp a:\xlcbt.de_ c:\excel\excelcbt\xlcbt.dex
   decomp a:\quickprv.cb_ c:\excel\excelcbt\quickprv.cbt




7. Insert the Microsoft Excel version 5.0 Setup Disk 8 into drive A. Or, if you installed Microsoft Excel from Microsoft Office version 4.2, insert the disk number listed in the first column in step 8 below.



8. Type the following MS-DOS commands:

   3 decomp a:\93sales.xl_ c:\excel\excelcbt\93sales.xls
   3 decomp a:\accounts.xl_ c:\excel\excelcbt\accounts.xls
   3 decomp a:\analysis.xl_ c:\excel\excelcbt\analysis.xls
   3 decomp a:\art.xl_ c:\excel\excelcbt\art.xls
   3 decomp a:\budget.xl_ c:\excel\excelcbt\budget.xls
   15 decomp a:\cbtlib4.dl_ c:\excel\excelcbt\cbtlib4.dll
   3 decomp a:\chart.xl_ c:\excel\excelcbt\chart.xls
   3 decomp a:\chart2.xl_ c:\excel\excelcbt\chart2.xls
   3 decomp a:\excelcbt.cb_ c:\excel\excelcbt\excelcbt.cbt
   8 decomp a:\excelles.cb_ c:\excel\excelcbt\excelles.cbt
   2 decomp a:\exotic.fm_ c:\excel\excelcbt\exotic.fmt
   3 decomp a:\exotic.wk_ c:\excel\excelcbt\exotic.wk1
   4 decomp a:\home.xl_ c:\excel\excelcbt\home.xls
   3 decomp a:\parts.wk_ c:\excel\excelcbt\parts.wk1
   3 decomp a:\parts.fm_ c:\excel\excelcbt\parts.fmt
   4 decomp a:\products.xl_ c:\excel\excelcbt\products.xls
   4 decomp a:\qtrsales.xl_ c:\excel\excelcbt\qtrsales.xls
   2 decomp a:\sales.xl_ c:\excel\excelcbt\sales.xls
   3 decomp a:\schedule.wk_ c:\excel\excelcbt\schedule.wk1
   3 decomp a:\schedule.fm_ c:\excel\excelcbt\schedule.fmt
   4 decomp a:\stocks.xl_ c:\excel\excelcbt\stocks.xls
   4 decomp a:\summary.xl_ c:\excel\excelcbt\summary.xls
   4 decomp a:\trend.xl_ c:\excel\excelcbt\trend.xls
   4 decomp a:\vbstock.xl_ c:\excel\excelcbt\vbstock.xls

1. Open the EXCEL5.INI file, which is typically located in the OS2\MSDOS\WINOS2 directory. (To edit this file use a text editor such as Notepad or OS/2 System Editor.)



2. In the [Microsoft Excel] section of the EXCEL5.INI file add the following line:

   CBTLOCATION= c:\excel\excelcbt

   NOTE: CBTLOCATION is case sensitive.



3. Save the EXCEL5.INI file and exit the text editor.

Additional query words: missing

Keywords : xlwin
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :