Author Topic: Error msg opening Excel re: BfX  (Read 4007 times)

Bart

  • Guest
Error msg opening Excel re: BfX
« on: April 28, 2011, 02:09:20 PM »
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

  • Administrator
  • Full Member
  • *****
  • Posts: 237
    • View Profile
Re: Error msg opening Excel re: BfX
« Reply #1 on: April 28, 2011, 10:54:54 PM »
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 ....