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?
SHUEYLLCAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

redrumkevCommented:
SHUEYLLC,

How are you doing?

What is your version of Office 2010, 32-bit or 64-bit?

If on 32-bit, try the following:
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... (reference: http://www.mrexcel.com/forum/showthread.php?t=467397)

See this for 64-bit issues:http://www.excelforum.com/excel-general/768964-indirect-references-to-closed-external-workbooks-in-64-bit-excel-2010-a.html

If you are one a 64-bit system you could uninstall and install 32-bit version. You could also dual boot into a 32-bit O/S with 32-bit version of Excel 2010 installed. I would only recommend this if you require the memory size afforded by the 64-bit version of Office.

Kevin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SHUEYLLCAuthor Commented:
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?
0
SHUEYLLCAuthor Commented:
Very helpful.
0
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

SHUEYLLCAuthor Commented:
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?
0
redrumkevCommented:
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
0
redrumkevCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.