PKPD Tools

Downloads for Excel

PKPD Tools for Excel Add-in Installation Guide

What You’re Installing

Two Excel add-ins for pharmacokinetic/pharmacodynamic analysis:

  • PKPD Tools – Core analysis functions and utilities
  • PKPD Drug Library – Drug parameter database and functions

Before You Start

  • Check your Excel version (see instructions below)
  • Install required runtime files (see instructions below)

Check Your Excel Version

You must use the correct version (32-bit or 64-bit) or the add-ins won’t work.

  1. Open Excel
  2. Go to File → Account
  3. Click About Excel
  4. In the dialog that opens, look at the first line:
    • If it says “Microsoft Excel for Microsoft 365 MSO (Version XXXX Build XXXX) 64-bit” → You have 64-bit Excel
    • If it says “Microsoft Excel for Microsoft 365 MSO (Version XXXX Build XXXX) 32-bit” → You have 32-bit Excel
    • For older Excel versions, the format is similar but may show “Excel 2019”, “Excel 2016”, etc.
  5. Close Excel completely before installation.

Install Required Runtime Files

The add-ins require Microsoft Visual C++ runtime files to function. Most computers don’t have these installed unless you’re a developer.

You must install the version that matches your Excel architecture:

Installation steps:

  1. Click the appropriate link above
  2. Download the file
  3. Right-click the downloaded file and select “Run as administrator”
  4. Follow the installation prompts
  5. Restart your computer after installation

If you skip this step, the PKPD Tools will not function.

Installation Steps

Step 1: Download the XLL Files

Download the correct PKPD Tools zip file (pkpdtools32.zip or pkpdtools64.zip) that matches your Excel version (32-bit or 64-bit):

PKPD Tools Add-Ins for 32 bit Excel for Windows

PKPD Tools Add-Ins for 64 bit Excel for Windows

Step 2: Extract and Copy Files

  1. Extract the downloaded zip file to any location
  2. Create a folder for the add-ins, such as:
    • C:\Users\[YourName]\Documents\PKPDTools\
    • Or any location you prefer
  3. Copy these files to your chosen folder:
    • If you have 32-bit Excel: Copy Tools2012x32.xll and DrugLibx32.xll
    • If you have 64-bit Excel: Copy Tools2012x64.xll and DrugLibx64.xll

Step 3: Unblock the Files (Important!)

Windows blocks downloaded files for security. You must unblock each XLL file:

  1. Right-click on each .xll file
  2. Select Properties
  3. At the bottom of the Properties dialog, check the “Unblock” box
  4. Click OK
  5. Repeat for both XLL files

If you skip this step, Excel will refuse to load the add-ins.

Step 4: Load the Add-ins in Excel

  1. Open Excel
  2. Go to File → Options
  3. Click Add-ins (in the left menu)
  4. At the bottom of the dialog:
    • Make sure “Excel Add-ins” is selected in the dropdown
    • Click “Go…”
  5. In the Add-ins dialog that opens:
    • Click “Browse…”
    • Navigate to the folder where you copied the XLL files
    • Select one XLL file (e.g., Tools2012x32.xll or Tools2012x64.xll) and click Open
    • The add-in should now appear in the list with a checkmark
  6. Repeat step 5 for the second XLL file (e.g., DrugLibx32.xll or DrugLibx64.xll)
  7. Click OK to close the dialog

Step 5: Verify Installation

  • The PKPD Tools functions should now be available in Excel
  • The add-ins will automatically load each time you open Excel
  • You can manage them anytime through File → Options → Add-ins

Troubleshooting

“Excel can’t load the add-in” or “The specified module could not be found”

  • Make sure you installed the required runtime files (and restarted your computer)
  • Make sure you unblocked the files (Step 3)
  • Verify you’re using the correct architecture (32-bit vs 64-bit) for both Excel AND the runtime files

“Add-in not found”

  • Check that the XLL files are in the location you specified
  • Make sure the files weren’t moved after installation

“Security warning” messages

  • This usually means the files weren’t properly unblocked
  • Go back to Step 3 and unblock all XLL files

Still not sure about your Excel version?

  • In Excel: File → Account → About Excel
  • Look for either “32-bit” or “64-bit” in the version information
  • Many Excel installations are 64-bit
  • We both run 32-bit Excel on 64-bit Windows. So, always check to be sure

Uninstalling

To remove the add-ins:

  1. Go to File → Options → Add-ins → Go
  2. Uncheck the add-ins you want to remove
  3. Delete the XLL files from your folder

PKPD Tools PDF (Booklet)

Description: A version of the pdf (2009) booklet about the original pkpddrugs.xll and pkpdtools.xll files. It contains now outdated information about the how to use the Function Wizard, Formula Arrays, and installation of the software. It was used by registrants of the original workshops in Berlin (April 2009), Singapore (2011) and Seoul, Korea (April 2012). Unfortunately, given all the many changes to the interface of Excel over the years, this pdf is well and truly out of date, but still provides some useful insights into the various functions. As time permits, we hope to provide updated information about the functions and drug library on this site.