+ Reply to Thread
Results 1 to 6 of 6

Issues with Morefunc

  1. #1
    Registered User
    Join Date
    03-09-2020
    Location
    Dorset
    MS-Off Ver
    Office 365
    Posts
    2

    Angry Issues with Morefunc

    Hello,

    I use an excel based estimating system which works well.

    I've recently moved to a newer computer and cant get the excel working.

    I've copied the exact files installed Morefunc and have updated the file locations but am not getting much luck !

    It wont pull the information from the costing system into the "seating" excel and im out of ideas. The person that originally used to help with these things no longer works for the company so i cant ask them for advise.

    Because the file size would be too big ive just added a "seating excel" and then in the costing system only added one option (the seat options so it should still pull the costings through)

    Every time i start up excel i am getting this message: the file format and extension of "Morefunc.xll" dont match. I was using Morefunc version 4.2 but on this new computer i have the newest version.

    Im confident the only issue is to do with the Morefunc. Why is it now poping up with the error ? I've noticed on the old costing system the Add in is called "Morefunc (add-in functions)" but on the new system that isn't working its just called "Morefunc". Both are .xll files but the new system seems to think the file & format dont match ?

    I'm hoping one of you Excel wizards can help me fix it !!! If you do i am happy to make a donation.
    Last edited by Arsenal12321; 03-11-2020 at 03:26 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Issues with Morefunc

    Morefunc was originally developed for older versions of Excel (i.e. those which used the .xls format files, XL2003 and earlier). I don't think there has been any recent development done on it.

    I have seen comments on the forum that it also works in XL2007 and XL2010, but nothing after those versions.

    It might be that Excel has now evolved so far beyond those early versions, that external software like morefunc is no longer compatible.

    Pete

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Issues with Morefunc

    Hi and welcome

    in any case we are not allowed to change/adapt proprietary code, even it was adapted to recent XL versions.
    Try contacting the author/website of the add-in for further help ( if any).

  4. #4
    Registered User
    Join Date
    03-09-2020
    Location
    Dorset
    MS-Off Ver
    Office 365
    Posts
    2
    Is there a way of me getting excel 2007 onto my windows 10 computer?

    I currently have an office 365 account which will mean I’m more than likely running a version of excel to recent for Morefunc

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Issues with Morefunc

    I don't know but you will need a 32bit version of Excel.
    There should be lots of information on the Net, but perhaps use a VM to install 2007?

  6. #6
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Issues with Morefunc

    Were you using 32-bit Excel before, and are you now using 64-bit Excel? If so, MOREFUNC.XLL is a 32-bit add-in, so it may not work with 64-bit Excel. You could try switching to 32-bit Office.

    Which MOREFUNC add-in functions are no longer working? FWIW, if you're really using Office 365, your Excel may support spilled formulas and dynamic arrays, and there are built-in replacements for several MOREFUNC functions. OTOH, if your workbook uses a lot of regular expression functions or SETV/GETV, ARRAY.JOIN or THREED, you'll have to replace those with VBA user-defined functions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using MoreFunc with Excel 2010/alternative to MoreFunc?
    By fgunning in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 12-03-2013, 01:55 PM
  2. [SOLVED] MoreFunc - Vsort
    By Gallinski in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2013, 08:32 PM
  3. [SOLVED] Where to find Morefunc
    By mathieuv in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-04-2013, 01:55 PM
  4. How to use Morefunc for Commercial use
    By Granberg in forum Excel General
    Replies: 3
    Last Post: 01-23-2012, 06:33 AM
  5. #ref for Morefunc addin
    By mp16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2007, 01:30 PM
  6. [SOLVED] MOREFUNC
    By nemadrias in forum Excel General
    Replies: 2
    Last Post: 06-26-2006, 12:00 PM
  7. [SOLVED] Morefunc
    By Becks in forum Excel General
    Replies: 3
    Last Post: 04-25-2006, 10:25 AM
  8. Morefunc
    By Dave 2005 in forum Excel General
    Replies: 1
    Last Post: 11-08-2005, 07:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1