Adding an add-in to Excel is easy
For starters, check if your copy of Excel has had all updates.
Excel 2003, 2007 and the 32 bits
Excel 2010 use the same version of BfX.xll. BfX.xll automatically
detects which version of Excel is runnung and adapts. The 64-bit
version of Excel 2010 uses BfX64.xll.(what
is an .xll file?
Should you check it for virusses?)
Using the Installer
Most installations require the automatic installer. On these computers,
auxilary files on which BfX.xll
depends are not present. The installer puts BfX and some auxilary files
from Microsoft on your computer. If these are
present then you could just refresh the BfX.xll or the BfX64.xll. To upgrade BfX this could work. If not, use the installer to upgrade the Microsoft files too.
The installation can be checked by
starting Excel and trying to use BfX (e.g. enter =bfx_help() in a
technically everything is allright one can start immediately (see right
panel on this page) or download the Excel workbooks that
illustrate the use of BfX. If you can't install BfX then start the
It is not nessecary to know all
the ins and outs of add-in installation, but if you would like to know,
To uninstall BfX.xll or BfX64.xll,
you simply delete BfX
add-in list, close Excel, and delete BfX.xll or BfX64.xll from your
automatically the folder you want to
put BfX.xll/BfX64.xll in. Download the Excel2003
workbook or the Excel2007/2010
workbook to find recommended default locations automatically.
These workbooks contain macros. Push the button on the worksheet to
determine your recommended locations. Copy the locations (and paste
simply choose a location
BfX (< 200kB). Use the
button to place it in the folder you have found or created in step 1.
You can also download the zipped installer programs for Excel2003, 2007 and 2010 32 bit or Excel2010 64 bit. Extract
them in the same folder:
you put them in a special folder where you can keep them as long as you
use BfX. Then you can unistall BfX from this folder .
use a or the default folder and remove this folder
afterwards. You have to uninstall BfX via the configuration
Double click BfXSetup.msi
or BfXSetup64.msi to install. Move
or copy BfX.xll/BfX64.xll to
determined in step 1.
- Tell Excel where the .xll
|Click on the
"Tools menu", expand the menu if nessecary.
Click the "Excel option" button that is located at the bottom of Excels
Click "Add-Ins ..."
Click "Add Ins" and then, check if manage "Excel Add Ins" is listed ,
then click "Go ...".
Click Browse... and
the folder where you have stored BfX.xll.
and surf to the
folder where you have stored BfX.xll.
and surf to the
folder where you have stored BfX.xll or BfX64.xll.
Select the BfX.xll or
To check the installation
- Create a new worksheet.
- Enter in an empty cell
=bfx_help(). BfX is not installed correctly when you get an error.
- To kick start, generate
as displayed on the right pannel. Use =bfx_help(n) where n=0,
2, ..., to about 100. This generates a list and explanation of BfX
- Additional information
found via =bfx_help2(n)
n=0, 1, 2, ..., to about 70. With bfx_help2 you generate a list of
units and drag functions that is supported.
installation of BfX.xll
|To start using BfX
withhout reading all the workbooks:
where n=1, 2, to about 100
BfX has a built in help facility. Type =bfx_help(n) where n=0...about
100. The input on the left in Excel 2007 generates the output above.
Use a fixed font like Courier New for the nicest layout.
Help in Excel 2003, generated with =bfx_help(n) where n=0,