APEx: Analysis of Processes with Excel
An Excel Add-In to integrate the tabular data found in Felder, Rousseau, and Bullard's Elementary Principles of Chemical Processes and to assist students in learning to solve systems of algebraic equations using Excel's Solver tool.
APEx Documentation (READ ME BEFORE ATTEMPTING TO USE THE ADD-IN) Revised 9/23/14, new revision in progress
Recommended for Mac Office 2011, Mac Office 2016, Windows Office
2010, Windows Office 2013, Windows Office 2016, 32-bit versions only.
APEx Excel Add-in 1.12 (RIGHT CLICK AND SELECT "SAVE LINK AS..." or "SAVE TARGET AS... ." DO NOT OPEN IN EXCEL, RECOMMENDED TO BE INSTALLED BEFORE USE-- DO NOT DOUBLE-CLICK AFTER DOWNLOAD. SEE DOCUMENTATION. )
Is Excel non-responsive when starting after installing APEx? On October 21, 2016, Microsoft introduced an update for Office that prevents VBA add-ins from behaving as intended. If your version of Excel is on the Current Channel Version: 1609 (Build 7369.2038), you are likely seeing this issue. You can check the version by clicking on the File tab and selecting Account in Excel. On November 9, 2016, Microsoft released an update which fixed this issue. If you are experiencing problems with Excel 2016 for Windows hanging on startup or loading APEx, go to File/Account, click on the Update Options button, and select Update Now.
Important Notice for Mac Office 2016 users. In August 2016, Microsoft updated its recommended version of Excel 2016 for Mac to a 64-bit version. This update renders many Excel add-ins inoperable. The recommended solution is to revert to the 32-bit version of Excel 2016 for Mac as documented by Microsoft here. You are looking for the Office 2016 for Mac 15.25.1 32-bit (legacy compatibility) option for Excel, which is at of 8/29/2016: Download the Excel package now
Is APEx not loading when you restart Excel after installation? Recent updates to Microsoft Office require that you make the folder in which you install APEx a "Trusted Location". To fix this, go to the File tab, then select Options. Now select Trust Center from the sidebar. Click the Trust Center Settings button, then select Trusted Locations from the sidebar. If you have placed APEx.xlam anyplace but one of the list locations, click Add new location. Click Browse and navigate to the location where APEx.xlam is saved. Click OK four times to exit and restart Excel. If APEx is installed, it should now load.
APEx Excel Tutorial Workbook (open only after installing APEx or functions will return errors)
Use the spacebar to pause the video as needed. Refer to the documentation for more detail.
David L. Silverstein, Ph.D., P.E.
University of Kentucky