Morefunc release for Excel 2010

[cowinsm]

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.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
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. <o></o>
<o></o>
Thanks for your help.<o></o>

 

[niketya]

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

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.

 

[pdecrocq]

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 !

 

[MUSTAFAINE]

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...

Thank you Colin, that trick solved the problem.

 

[marknhopgood]

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...

Thank you Colin. Here's how I got it to work for 64 bit.

Here's how I made it work for 64 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 (x86)\Morefunc). Add references to both Morefunc.xll and Morefunc12.xlam (do this one at a time). From there you should be up and running...

If you need to get the developer tab on excel, do the following. File, Options, Customize Ribbon then on the right, check the Developer tab and click OK