Hi there,
I have a question: can I use the INDIRECT function for a cell from a closed workbook? If not, please give me an alternative solution.
Thanks all who tried to help me.
Hi there,
I have a question: can I use the INDIRECT function for a cell from a closed workbook? If not, please give me an alternative solution.
Thanks all who tried to help me.
i think the indirect.ext is what you want.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
INDIRECT(as i know) does not works in closed workbooks. Take a look to teylyn suggestion in this thread.
http://www.excelforum.com/excel-gene...-workbook.html
Maybe will helps you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Indirect.ext... I haven't that function in Microsoft Excel 2010.
I've searched a lot for MOREFUNC and I still don't find any link to download it. I appreciate an answer for my questions:
1. the patch is free license?
2. it's compatible with Excel 2010? cause i heard some crashes.
3. Excel 2013 solved the problem with the dynamic link to closed workboks for INDIRECT function?
4. is there a reliable alternative solution for INDIRECT function with closed workbooks?
Thank you.
you can try downloading morefunc from here http://www.ashishmathur.com/tag/morefunc/
in step 4 you'll find the download link
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks