Error msg opening Excel re: BfX

Started by Bart, April 28, 2011, 03:09:20 PM

Previous topic - Next topic

Bart

I have MS Excel2007, and have carefully installed file to location and clicked on tick-boxes in Options but on opening Excel get a dialog box with the following message;
"The file you are trying to open 'Bfx.xll', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening."

If I click on yes a sheet of unreadable text opens.

Please help for ideas of where I have gone wrong in this install.

admin

Paul,

I just checked on a fresh vista32bit/excel 2007 installation the setup procedure.
I only downloaded bfxsetup.zip
I extracted the file into a certain folder (the desktop folder)
I ran bfxsetup
I opened excel 2007 and checked that bfx was not installed (e.g. =bfx_ ... does not give a response)
I went to the excel options menu
I opened add-ins
I pressed GO to manage excel addins
I browsed to the install directory and  added the bfx.xll
that was accepted and sow the bfxxll2007 addin in the addin list
I calculated something with bfx.

everything worked fine.

Then I googled on "xll The file you are trying to open is in a different format than specified by the file extension"

and found

http://www.mrexcel.com/forum/showthread.php?t=484698

Then I googled on "The file you are trying to open is in a different format than specified by the file extension"

http://www.itexperience.net/2008/03/17/excel-2007-error-different-format-than-specified-by-the-file-extension/

and similar links.

Both links seem to have remedies.

seems that you were uprgrading to Excel 2007 ....