Excel 2013 Function: INDIRECT.EXT add-in
up vote
0
down vote
favorite
I am using Excel 2013, and wanted to download Morefunc Addin, but can't get it to work. I need to use it to extract data from multiple cells in closed excel files. I understood with it added to excel, I could enter the following FUNCTION: =INDIRECT.EXT and it would allow me to specify a folder and a common cell(s) and sheet in all workbooks within the folder and it will return their values.
search microsoft-excel-2013 extension
asked May 6 '15 at 15:13
Leo Gillman
111
add a comment |
up vote
0
down vote
favorite
I am using Excel 2013, and wanted to download Morefunc Addin, but can't get it to work. I need to use it to extract data from multiple cells in closed excel files. I understood with it added to excel, I could enter the following FUNCTION: =INDIRECT.EXT and it would allow me to specify a folder and a common cell(s) and sheet in all workbooks within the folder and it will return their values.
search microsoft-excel-2013 extension
asked May 6 '15 at 15:13
Leo Gillman
111
I am sure you can quote cells from other documents by typing "=" in the desired cell on the first excel document,opening the target document and select the cell there... I recall doing this before. It then puts a formula in the cell that says something like ='documentname.xlsx!: A1'. If you are having trouble with the extension why not try this? It can also be done within one Excel document per sheets too.
– ThunderToes
May 6 '15 at 15:22
Are you sure that add-in is compatible with your Excel 2013? I saw a note on C|NET that states; "Version 5 adds compatibility with Excel 2007. It still works in the 32-bit versions of Excel 2010 and 2013 but not in 64-bit versions."
– CharlieRB
May 6 '15 at 15:30
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am using Excel 2013, and wanted to download Morefunc Addin, but can't get it to work. I need to use it to extract data from multiple cells in closed excel files. I understood with it added to excel, I could enter the following FUNCTION: =INDIRECT.EXT and it would allow me to specify a folder and a common cell(s) and sheet in all workbooks within the folder and it will return their values.
search microsoft-excel-2013 extension
asked May 6 '15 at 15:13
Leo Gillman
111
I am using Excel 2013, and wanted to download Morefunc Addin, but can't get it to work. I need to use it to extract data from multiple cells in closed excel files. I understood with it added to excel, I could enter the following FUNCTION: =INDIRECT.EXT and it would allow me to specify a folder and a common cell(s) and sheet in all workbooks within the folder and it will return their values.
search microsoft-excel-2013 extension
search microsoft-excel-2013 extension
asked May 6 '15 at 15:13
Leo Gillman
111
asked May 6 '15 at 15:13
Leo Gillman
111
asked May 6 '15 at 15:13
Leo Gillman
111
asked May 6 '15 at 15:13
Leo Gillman
111
asked May 6 '15 at 15:13
Leo Gillman
111
111
I am sure you can quote cells from other documents by typing "=" in the desired cell on the first excel document,opening the target document and select the cell there... I recall doing this before. It then puts a formula in the cell that says something like ='documentname.xlsx!: A1'. If you are having trouble with the extension why not try this? It can also be done within one Excel document per sheets too.
– ThunderToes
May 6 '15 at 15:22
Are you sure that add-in is compatible with your Excel 2013? I saw a note on C|NET that states; "Version 5 adds compatibility with Excel 2007. It still works in the 32-bit versions of Excel 2010 and 2013 but not in 64-bit versions."
– CharlieRB
May 6 '15 at 15:30
add a comment |
I am sure you can quote cells from other documents by typing "=" in the desired cell on the first excel document,opening the target document and select the cell there... I recall doing this before. It then puts a formula in the cell that says something like ='documentname.xlsx!: A1'. If you are having trouble with the extension why not try this? It can also be done within one Excel document per sheets too.
– ThunderToes
May 6 '15 at 15:22
Are you sure that add-in is compatible with your Excel 2013? I saw a note on C|NET that states; "Version 5 adds compatibility with Excel 2007. It still works in the 32-bit versions of Excel 2010 and 2013 but not in 64-bit versions."
– CharlieRB
May 6 '15 at 15:30
I am sure you can quote cells from other documents by typing "=" in the desired cell on the first excel document,opening the target document and select the cell there... I recall doing this before. It then puts a formula in the cell that says something like ='documentname.xlsx!: A1'. If you are having trouble with the extension why not try this? It can also be done within one Excel document per sheets too.
– ThunderToes
May 6 '15 at 15:22
I am sure you can quote cells from other documents by typing "=" in the desired cell on the first excel document,opening the target document and select the cell there... I recall doing this before. It then puts a formula in the cell that says something like ='documentname.xlsx!: A1'. If you are having trouble with the extension why not try this? It can also be done within one Excel document per sheets too.
– ThunderToes
May 6 '15 at 15:22
Are you sure that add-in is compatible with your Excel 2013? I saw a note on C|NET that states; "Version 5 adds compatibility with Excel 2007. It still works in the 32-bit versions of Excel 2010 and 2013 but not in 64-bit versions."
– CharlieRB
May 6 '15 at 15:30
Are you sure that add-in is compatible with your Excel 2013? I saw a note on C|NET that states; "Version 5 adds compatibility with Excel 2007. It still works in the 32-bit versions of Excel 2010 and 2013 but not in 64-bit versions."
– CharlieRB
May 6 '15 at 15:30
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
Sorry my comment wasn't exactly correct, but I have found a link that can do this without extensions. here
you can type this =(['name of document'.xlsx]Sheet1!A1) to get the cell value of cell A1 in the workbook saved in a location that you choose after the formula is entered.
You can obviously change this to suit your needs per cell reference and sheet number/name.
Hope this helps
answered May 6 '15 at 15:32
ThunderToes
25031028
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Sorry my comment wasn't exactly correct, but I have found a link that can do this without extensions. here
you can type this =(['name of document'.xlsx]Sheet1!A1) to get the cell value of cell A1 in the workbook saved in a location that you choose after the formula is entered.
You can obviously change this to suit your needs per cell reference and sheet number/name.
Hope this helps
answered May 6 '15 at 15:32
ThunderToes
25031028
add a comment |
up vote
0
down vote
Sorry my comment wasn't exactly correct, but I have found a link that can do this without extensions. here
you can type this =(['name of document'.xlsx]Sheet1!A1) to get the cell value of cell A1 in the workbook saved in a location that you choose after the formula is entered.
You can obviously change this to suit your needs per cell reference and sheet number/name.
Hope this helps
answered May 6 '15 at 15:32
ThunderToes
25031028
add a comment |
up vote
0
down vote
up vote
0
down vote
Sorry my comment wasn't exactly correct, but I have found a link that can do this without extensions. here
you can type this =(['name of document'.xlsx]Sheet1!A1) to get the cell value of cell A1 in the workbook saved in a location that you choose after the formula is entered.
You can obviously change this to suit your needs per cell reference and sheet number/name.
Hope this helps
answered May 6 '15 at 15:32
ThunderToes
25031028
Sorry my comment wasn't exactly correct, but I have found a link that can do this without extensions. here
you can type this =(['name of document'.xlsx]Sheet1!A1) to get the cell value of cell A1 in the workbook saved in a location that you choose after the formula is entered.
You can obviously change this to suit your needs per cell reference and sheet number/name.
Hope this helps
answered May 6 '15 at 15:32
ThunderToes
25031028
answered May 6 '15 at 15:32
ThunderToes
25031028
answered May 6 '15 at 15:32
ThunderToes
25031028
answered May 6 '15 at 15:32
ThunderToes
25031028
25031028
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f911479%2fexcel-2013-function-indirect-ext-add-in%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I am sure you can quote cells from other documents by typing "=" in the desired cell on the first excel document,opening the target document and select the cell there... I recall doing this before. It then puts a formula in the cell that says something like ='documentname.xlsx!: A1'. If you are having trouble with the extension why not try this? It can also be done within one Excel document per sheets too.
– ThunderToes
May 6 '15 at 15:22
Are you sure that add-in is compatible with your Excel 2013? I saw a note on C|NET that states; "Version 5 adds compatibility with Excel 2007. It still works in the 32-bit versions of Excel 2010 and 2013 but not in 64-bit versions."
– CharlieRB
May 6 '15 at 15:30