Link to home
Start Free TrialLog in
Avatar of SHUEYLLC
SHUEYLLC

asked on

INDIRECT.EXT in Excel 2010

Does INDIRECT.EXT work in 2010?  After downloading and running the setup.exe for Morefunc UDFs three times, the INDIRECT.EXT never appears amongst the Informational functions in the More Functions group of the formula bar.  Is it because Morefunc was written for earlier versions of Excel or am I possibly needing to take or avoid some other step?
ASKER CERTIFIED SOLUTION
Avatar of redrumkev
redrumkev
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SHUEYLLC
SHUEYLLC

ASKER

Hi Kevin,

Thanks for the links and advice.  The value=x86 in the Bitness registry file so I'm using 32-bit Office 2010.

After browsing for and installing all three MoreFunc add-ins one by one through the developer tab, the INDIRECT.EXT function still does not appear in either the information section of the More Functions or Look-up & Reference functions of the formula bar.   I shut down and re-opened Excel each time to no avail.  Does it matter that the Windows 7 OS is running 64-bit?
Very helpful.
Finally realized there are two MoreFunction areas after installing MoreFunc.  The INDIRECT.EXT works like INDIRECT and won't update links without the other file being opened.  Now the issue is why doesn't INDIRECT.EXT work like a direct link as intended and keep the values found after closing the files?
SHUEYLLC,

If you copy your last comment and start a brand new question with it in the Excel forum, it will get a lot of views. Since this question has been closed, it is highly unlikely that anyone else will "see it" to comment on it.

Thank you for the grade!
Kevin
SHUEYLLC,

Hi! Ignore my comment above, I see you got help from rorya a few hours ago! Hopefully the developer can shed some light on this. Also, if you were to break down what exactly you wanted to do with the function, it would possible to build your own. Post an example of how you used it before (starting data/worksheet/workbook, etc) and what you want to accomplish, I am sure that it can be solved here by someone in the excel form.

I always recommend people to use the built-in functions when possible because they are generally faster, but in your case, it is not working or does not exist. So maybe creating one for your application is the right approach!?

Hope this helps,
Kevin