• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5633
  • Last Modified:

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?
0
SHUEYLLC
Asked:
SHUEYLLC
  • 3
  • 3
1 Solution
 
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
 
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now