Results 1 to 4 of 4

XLL file will not load

This is a discussion on XLL file will not load within the Excel Questions forums, part of the Question Forums category; I'm sorry if this has been asked and answered previously, but I did a search though the forums and was ...

  1. #1
    Board Regular
    Join Date
    Feb 2005
    Posts
    66

    Default XLL file will not load

    I'm sorry if this has been asked and answered previously, but I did a search though the forums and was unable to find an answer. I have an XLL file that I have been using for some time now. Recently I started trying to use that XLL file on a new computer and have been running into a problem. I have been able to successfully add the xll file to the add-ins list, but when I reopen excel I get an error box telling me:

    The file you are trying to open, xxx, 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 the file. Do you want to open the file now?

    If I click "Yes" it opens up the XLL file in excel and there is a bunch of garbage in all the cells.

    The XLL file was written for Excel 2007 so that is the only version of excel I have tried to use it on. I have been able to successfully get it to work on Windows XP, and Windows Vista Home. The latest try (which is the one not working) is on Windows Vista Enterprise.

  2. #2
    Board Regular
    Join Date
    Feb 2005
    Posts
    66

    Default Re: XLL file will not load

    Update: I need to take something back. It appears that the xll file is NOT loading correctly. I have no idea why. What would cause excel on one OS to recognize the format but not on another?

  3. #3
    Board Regular
    Join Date
    Feb 2005
    Posts
    66

    Default Re: XLL file will not load

    It looks like the problem is with the macro settings in the Trust Center. It is currently set to "Disable all macros with notification". However everything is grayed out so I can't make any changes to this. I presume that this is due to a group policy here at work. Is there anyway I can override those settings by adding entries into the registry? If so what parameters do I need to add.

    Thanks,

  4. #4
    New Member
    Join Date
    Aug 2010
    Posts
    1

    Default Re: XLL file will not load

    My suggestion is to check if your XLL depends on msvcr100.dll. And if it does, then check if this dll exists in c:\windows\system32 folder.
    You can check dependencies using depends.exe.

    This was my reason why fu**ing excel was not able to load generic.xll on fresh OS. With exactly the same error message as you have.
    I hate excel and it's ****ty code. It doesn't show any details in the error message describing the problem. It just doesn't work.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com