The PC*MILER|Rail installation normally copies the .xla file mentioned  into the XLSTART folder of your Microsoft Office installation to enable autoloading in Excel.  This means that the Connect Excel function should be available automatically when you open Excel.


To check this, open Excel and select File menu > Options > Add-Ins and make sure PC*MILER|Rail-Spreadsheets is listed as an add-in. 


The steps below only need to be used in case of a malfunction or with older versions of Microsoft Office.  They describe how to manually install/uninstall the pcrss32.xla file and enable autoloading of the Connect Excel functions.


Enabling the Add-In Manually

If you are running Microsoft Office 2003 (or older):

  1. Start Excel.
  2. In the Tools menu, select Add-Ins… > Browse.
  3. Navigate to the folder where PC*MILER|Rail is installed and open the Excel folder. The default location of the Excel folder is …\ALK Technologies\PCRWINXX\Connect\Excel.  (“XX” refers to the PC*MILER|Rail version number, for example PCRWIN24).
  4. In the …\Excel folder, click on the PCRSS32.XLA file, then click OK.
  5. If you're installing from the network, a dialog box will appear that reads "Copy 'PCRSS32.XLA' to Microsoft Excel Add-In Library?" You can choose Yes to make a local copy or No if you don't wish to. In either case PC*MILER|Rail-Spreadsheets will install properly.
  6. In the Add-Ins dialog box, PC*MILER|Rail-Spreadsheets will appear in the list of products with a check next to it. Click OK to continue. The PC*MILER|Rail-Connect Excel functions are now ready to be used and will be available every time you start Excel.


If you are running Microsoft Office 2007 (or newer):

  1. Click on the Microsoft symbol in the upper left hand corner of the Excel window.
  2. In the list that opens, at the bottom click the Excel Options button.
  3. In the dialog box that opens, in the left hand column menu click on Add-Ins.
  4. In the right hand side of the dialog box, there's a drop down menu next to Manage. Scroll that drop down menu and choose Excel Add-Ins. Click the Go button to continue.
  5. In the Add-Ins dialog box that opens, click Browse and navigate to the folder where PC*MILER|Rail is installed and go to the Excel folder. The default location of the Excel folder is …\ALKTechnologies\PCRWINXX\Excel. (“XX” refers to the PC*MILER|Rail version number, for example PCRWIN24.)
  6. In the …\Excel folder, click on the PCRSS32.XLA file, then click OK.
  7. In the Add-Ins dialog box, “PC*MILER|Rail-Spreadsheets” will appear in the list of products with a check next to it.
  8. Click OK to continue.
  9. Next, you must enable Macros in Office 2007. To do so, click on the Microsoft symbol in the upper left hand corner of the screen.
  10. In the list that opens, at the bottom click on the Excel Options button.
  11. In the dialog box that opens, in the left hand column menu listing click on Trust Center.
  12. In the left hand column, click on Add-Ins and uncheck each box on the right side of the window.
  13. In the left hand column, click on Macro Settings. In the right hand side of the window, under the question "For macros in documents not in a trusted location", click the radio button next to the last option (Enable all macros). At the bottom, leave the box checked next to "Trust access to the VBA project object model."
  14. Click OK at the bottom of the dialog box to exit. The PC*MILER|Rail-Connect Excel functions are now ready to be used and will be available every time you start Excel.


Enabling Autoloading of PC*MILER|Rail-Connect in Excel

To enable autoloading of the Add-In when Excel is opened, copy the file pcrss32.xla to the XLSTART folder within the Microsoft Office installation folder on your computer (usually C:\Program Files\Microsoft Office\Office\XLSTART).


Disabling Autoloading of PC*MILER|Rail-Connect in Excel

Remove the file pcrss32.xla from the XLSTART folder within the Microsoft Office installation folder on your computer (usually C:\Program Files\Microsoft Office\Office\XLSTART).


Disabling the Add-In Manually

  1. Start Excel.
  2. Under the Tools menu, choose Add-Ins.
  3. Locate PC*MILER|Rail-Spreadsheets in the list of Add-Ins and click to remove the checkmark.
  4. Click OK.


The PC*MILER|Rail functions are now removed. They won’t be available the next time you start Excel.