Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!


Free Excel Forum

Morefunc With Excel 2010

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More


From where can i download the Morefunc add-in and does it also work with Excel 2010?


View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Sort Worksheet Tabs - Ascending or Descending Order
- This macro will sort all of the worksheets in the current workbook. It can sort in ascending or descending order. This
Reverse Cell Contents (Mirror)
- This macro will completely reverse the contents of any cell. This means that if you have a cell which reads "My Text
Delete Empty Columns
- This macro will delete columns which are completely empty. This means that if there is no data within the entire column
Reverse Row or Column Order in a Worksheet
- This macro reverses the order of a selected row or column in excel. It will completely reverse the data.
Remove All Data Validation from a Cell in Excel
- Remove all data validation from a cell in Excel with this free Excel macro. This is a great macro to use when you need

Similar Topics

Dear Smartest Excelers Around,

I recently installed Windows 7 (64 bit) and Excel 2010 (64 bit) and I can't seem to get the MoreFunc add-in to work.

I went to this site to download the add-in:

Then I directed the Add-in dialog box to look at the file named:


I then checked the box and closed and opened Excel.

I can see the new item added to the Ribbon and I can insert functions such as MCONCAT but Excel does not recognize them (I see a #NAME! error).

Any ideas on how to get MoreFunc add-in to work in Excel 2010 (64 bit) and Windows 7 (64 bit)?

Does anyone know when they will release the morefunc add-on for Excel 2010? I tried to ask the question on their website but it is all in a foreign language and could not figure out how to navigate the forum.

A few of my spreadsheets uses morefunc functions and I am a little worried about upgrading to 2010 until the new morefunc add-on is release.

Thanks for your help.

Hi there I asked a question a month or two ago and the resoultion was that I needed to download morefunc to my computer to get this function to work in excel. I downloaded it that day and it worked, however since then I had my computer changed and now I need to download this program again.

Does anyone have the link to download morefunc?





I am looking for a link to a version of Morefunc that includes the COUNTIF.3D function. I downloaded from the link above, but I still can't seem to use COUNTIF.3D. If I just type the formula into a cell, Excel doesn't seem to recognize it. I can see the Morefunc menu in my add formula window, but COUNTIF.3D does not appear there. From what I've been able to find out about this function, it is included in Morefunc 5.05; the link above appears to be Morefunc 5 (perhaps 5.0?).

Am I missing something? If so I would really appreciate any help anyone can provide. I tried downloading from another location, which looked to be the author's website, but the download link seems to be broken there. See:

If anyone has an alternate link it would be much appreciated.[/quote]

I am operating Windows 7 with Office 2010 Pro. I would like to use the MoreFunc 5.06 package so I can use the INDIRECT.EXT function. Does any one know if this add on will work for my version of excel and my OS? I have installed it but I am not seeing it anywhere.

Are there any alternative places to download MOREFUNC.XLL? The link at the Morefunc for Excel site is broken, and the forums seem currently busted as well.

Hi all,

I'm having a strange issue with the morefunc add-in. I got Excel 2010 at home and it worked fine (I can use the formulas and actually get the results I want).
However when I go back to work, and installed morefun on my work PC (with excel 2003), I can see morefunc in the insert function menu, but when I open the workbook I saved from home, all the correct results I had turned into "#Value!", I can see that when the workbook first got loaded the correct results was show for 1 sec before they all turned "#Value!".

I've checked the boxes for morefunc in the add-ins menu already, is it possible my work PC is somehow locked down for this add-in? Where can I check?

Many thanks

In trying to download ver 5.05 of morefunc I get a read error, attached. My system uses Excel 2007 Professional and Windows 7 Ultimate.
Is morefunc, particular the function Array.Join, not compatible with my system?


I see online many people are searching for a link that works to download the Morefunc v5.06 add in for Excel. Today, I successfully used the following link to download the softwa

Click on the button that says Telecharger (1 Mo). This site is not in English but the download button works and I have successfully installed this updated version of Morefunc on Excel 2007 (Windows XP 32bit).


FYI looks like is down

Alternative download location?
Know whether the MOREFUNC.xll addin is still in development?


I have found that my company needs to download the excel add-in called "morefunc.dll", for the purpose of using the "indirect.ext" function; however, our systems dept. is leary about doing this because of any problems it may cause. If anyone has an experience good or bad with this download, could you please respond? I'd also like to know if this add-in is backed by Microsoft? I couldn't find anything on their website about it.

Please help - if I can't get more info. on this, they won't go ahead with the download.



I have this problem with the morefunc add in.
I have this workbook which 2 of the worksheets requires function from the morefunc add in (indirect.ext).
I created them and they worked. But after i save them then reopen the work book again the #ref error appear for one of the worksheet but the other still works.
Is there anyone who have encounter the same problem and the answer to it?



I want to use Morefunc within VBA, but I only get it to work within the Excel Interface.

Morefunc is (correctly?) installed, both Morefunc and Morefunc12 are checked at "Excel-Options>Add-Ins>Active Application Add-Ins" (I am not 100% sure whether this are the correct menue names because I had to translate into english).

Actually, I can use Morefunc within Excel. For example, writing "Filename()" into a random cell returns the workbook's name.

However, calling "Filename()" with VBA doesn't work:

Dim strTest As String 
strTest = Application.FileName

Instead, I get Error 438: Object does not support this attribute or function

In other forums, using "strTest = FileName()" respectively "Application.Run(FileName)" is suggested but both return the error message "error during compilation: function or sub not defined"

So, I have two questions:
1) How do you call morefunc functions correctly in VBA? I assume there are several correct ways, but some confirmation would be good to eliminate one possible source of error
2) How can I check whether morefunc is correctly installed? (Since this is the only other source of error I can think of)

Thanks in advance!

Hello everybody,

I'm working in a larg set of excel files, i need to count values according to a specific criteria accross multipile sheets, i download morefunc 5.06 but countif.3d didn't work at all, Excel just doesn't recognize it, while it does recognize all other functions in Morefunc 5.06 package.

Please help.

I recently downloaded Morefunc for excel and have been playing around with some of the functions. Truth be told I downloaded morefunc for its EVAL function which, from what I understand can accomplish the following:

In A1:A3 (for instance)
a1 = 3
a2 = +
a3 = 5


And the result should be 8.

In any case, I was looking up documentation for morefunc, where I found this great page that explain and gives examples to all the functions*:

*All the functions EXCEPT for EVAL... which gives a page not found error when you click on it.

So, is there anybody that can give an example on how EVAL works?

Any help would be highly appreciated

P.S: it it helps I'm using Excel 2007 on a 32bit Windows Vista Home Premium.

Iv'e made a worksheet that uses INDIRECT.EXT from Morefunc.
I'm going to give this worksheet to a bunch of people and the problem is that they will - in most cases - not have morefunc.
It would be nice to have the worksheet to automaticly check if Morefunc is installed and popup a text to install it if it's not installed or, even better, begin to install it automaticly if it's not installed.

That's your thoughts about this?
Is this possible?
Or do you have better idea?
And yes, I want to use INDIRECT.EXT even though it makes trouble for the users.
Right now I've written a text in the beginning that explains that Morefunc have to be intsalled, but it just doesn't feel right.

I'm told I can embed Morefunc into my workbook by


but I can't find this option.

Can anyone help?

Okay so for work Im having to download loads of company payments, do certain validations and switch them from sheet1 to sheet 2.

my first problem is how to validate the dates in excel. for example my company waht excel to pick up whether the date is written right i.e 1/12/2010 instead of 1/12/10 so in their scenario valid dates.

heres some data im working with

14/06/2010 14/06/2010 14/06/2010 11/06/2010 09/06/2010 08/06/2010 08/06/2010 08/06/2010 08/06/2010 07/06/2010 07/06/2010 07/06/2010 07/06/2010 07/06/2010 07/06/2010 07/06/2010 04/06/2010 03/06/2010 03/06/2010

i need to get excel to validate dates in every cell

thanks for reading

This question has been asked by others but not answered. that I can find.

The morefunc addin works well in the spreadsheet but HOW do we access it from VBA ??
does not seem to work ?

Help Harry S.

I think Laurent Longre's moregfunc is great and it is often referred to on this forum. I am using Longre's MCONCAT extensively in a spreadsheet I am
building, it could be said to be the centre of the spreadsheet's

A few nights ago (Western Australian time - Tue 3rd Feb 2008)
- my Excel installation has ceased to allow it be part of it. I have
uninstalled and reinstalled morefunc. I have rebooted. I have downloaded a
new copyfrom CNet. I have run a repair on Excel. All to no avail. It is as though Excel has stopped being willing to allow morefunc to 'attach' itself to / 'lock on to' / install itself in the Excel formulas bar. I am using Excel 2007. I am also on Microsoft Auto Update for everything on my machine.

Unfortunately all I get, when trying to use the home site for morefunc, is
lots of errors; that is why I am resorting to here as I am unable to access
the software's own discussion forum. I also had to use CNet to actually get my download.

If anyone has any ideas for what might be going on, or what settings I could check on Windows / Excel / Norton, I would be most grateful.

Best regards

Philip Hunt
Medina, Kwinana
Perth, Western Australia
Graewood Business Services, Kwinana, Perth, Western Australia

I have downloaded the Morefunc program for countif3d, but curious as to would I have to use SumProductIF to perform the following function?



I've tried one of the Add-in functions of Morefunc

- date.diff(A1,,3)

Fantastic! unfortunately, it's in french...anyone could offer an english version?

Good day. This message was originally posted by error in the Lounge. How that happened, I have yet to figure out. Anyway, I recently posted a problem and the answer was to download the INDIRECT.EXT from Laurent Longre's website. I have tried Googling Longre, but every time that I get to the actual download command, I get a "Forbidden" access error message. Is he off-line for some reason? How do I register for access? Does anyone know where I can get a copy of the MoreFunc download?

Thanks, Dan...

For whatever reason, the MoreFunc add-in stopped working suddenly this morning (gives me #NAME? errors). Has this happened to anyone else? Is there any remedy outside of reinstallation?

I don't see the Morefunc add-in listed in the Recommended Add-ins... sticky. Is it no longer available?