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.

To the best of my knowledge it works with 2010 (32bit anyway).

Thank you, Rory.

Does anyone know if it works on the 64 bit version or any reason why it would work on the 32 bit version and not 64 bit version?

Hello Rory,

Did you actually getting it working with Excel 2010? I tried with a 32 bit machine, but it did not load properly. Please let me know if you got it working and which version of morefunc that you got working.

Thank you for your help.

cowinsm,

Just installed the morefunc version 5.0 on Excel 2010 32bit and it's working OK.

As far as I am aware it shouldn't work on 64bit excel, until the developer makes a 64 bit excel add-in available.

Hello niketya,

Thank you for your input.

Are you using Version 5.0? I tried to use this one and it does not load in. When I run it nothing shows up in excel 2010. Do you have any recommendations?

I just installed it and it works fine with Excel 2010 32 bit.

After you have installed it on your computer, open Excel, go to the developer tab on the ribbon, click on the add-ins button and browse to where it was installed (probably C:\Program Files\MoreFunc). Add references to both Morefunc.xll and Morefunc12.xlam (do this one at a time). From there you should be up and running...

cowinsm,

Yes I used version 5.0. Please follow Colin's explanation for getting the add-in to work.

Thank you everyone for your help. Colin's trick worked. I have it working on a 32 bit machine. I will let you know if it works on 64 bit machine when I install it.

Hello,
I have installed MoreFunc in XL 2010, but I have a workbook that makes XL crash each time I load it (it's full of INDIRECT.EXT() formulas). The sample workbooks (Exemples_Morefunc.xls) supplied with morefunc works ok.
Any ideas ?
Thanks
--Pierre
PS : I have added morefunc.xll and morefunc12.xlam to add-ins list.

Hello!
I managed to solve it and it now works. Actually, the workbook was using INDIRECT.EXT() and MOYPOND() (weighted average) functions.
I created a blank workbook from scratch and redesigned it all. It's still using the same functions and works now perfectly.
The only difference I can notice is that I supply a slightly different first argument to INDIRECT.EXT().
The crashing workbook uses =INDIRECT.EXT('fullpath\workbook.xls!name';FALSE), the working one uses =INDIRECT.EXT('fullpath\[workbook.xls]sheet!name';FALSE). I don't know is someone sees the problem.
Thank!
--Pierre

I think I got most answers to your judicious points. Yes the problems lies in inderect.ext function, but also in my workbook.
- I told you the sample workbook supplied with morefunc works okay (and it contains calls to indirect.ext).
- Both workbooks (supplied sample and my crashing workbook) open okay when morefunc is uninstalled.
I guess the only thing I can do is to reprogram the workbook starting from a fresh empty workbook and see when it crashes (if ever), ... or wait for the next release.
Thanks for your help anyway (unless you have more suggestions)
--Pierre
BTW: I don't have '07 avalaible anymore...!

To be more precise, when I open the workbook, XL almost immediately displays a recovery message box saying "Excel has encountered a problem and must close". If I check the "recover my work" checkbox, it just loops forever.

Sorry to insist... Noone's reading this forum ? Thanks for your help. --Pierre

I am not totally sure what the issue could be. I would suggest uninstalling morefunc and seeing if it works with out the add in. That way you will at least know that morefunc is causing the problem. Also, try opening another XL program without the indirect function. If that works then try running other functions within morefunc to see which function causes the crash.

Thanks for replying. I've already uninstalled and reinstalled morefunc several times. That didn't change the problem. The sample worksheet supplied with morefunc works OK. The one worksheet that crashes worked under XL 2007 and no longer with XL 2010. It's using only INDIRECT.EXT() function, but extensively. So that gives you the answer to the question about what function causes the problem (sorry I should have said it at first). --Pierre

Okay. It sounds like you narrowed it down to the indirect.ext function or the workbook. I would open a new workbook and attempt to use the indirect.ext function. If the function crashes Excel then that would tell me it is the indirect.ext function. I would then remove morefunc add in and see if the spreadsheet opens without crashing. If it is indeed morefunc, then the spreadsheet should open when the add in is removed. If it is the indirect.ext function, then you can either wait till the next release, reprogram the indirect.ext function or work on a work around.

If that function works properly in the blank worksheet and does not crash your Excel that would indicate there is something wrong with your workbook. It should also crash when the morefunc add in is removed. That means most likely there are other function in your spread sheet that are causing problems. I would open the spreedsheet in '07 and remove all the VBA and retry open the spreadsheet in '10. Hopefully you would be able to narrow down the VBA causing you the trouble.

According to the manual you must use Ctrl-Alt-F9 to update all values. The reason you need to use Ctrl-Alt-F9 is because the function is non-volatile. You could make the function volatile, but it might cause performance issues, if you care using this INDIRECT.EXT a lot.

Hope this answers your question. For more information have a look at the manual.

You're bloody right ! I don't know why the XL ribbon command "Calculate the sheet" doesn't do this. Also, its popup give Shift-F9 as hotkey.
Ctrl-Alt-F9 definitely works.
Thanks !

I have just carried out Colin's instructions on my 64 bit Windows 7 machine, and it is all working OK again.

I found my machine had it in C:\Program Files (x86)\Morefunc.

Thank you very much Colin.

Best regards

Philip

Reopening the worksheet more than one month later to update it, I find that the cells do not recalculate unless I edit their content (press F2 and enter, no change to cell contents). F9 or Shift-F9 produce nothing !
Another mystery ?
--Pierre

pdecrocq,


=INDIRECT.EXT('fullpath\workbook.xls!name';FALSE)
this is wrong because you are missing [] around the excel file name.


You should be using "" as well. See below.
=INDIRECT.EXT("'fullpath\[workbook.xls]!sheet1'a1;FALSE")
this is non-volatile, therefore you must use Ctrl-Alt-F9 to update your cells.