Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect Formula
I want to use the indirect formula so I can put the directory path in a cell
and link to it. I want to link to a a spreadsheet located here - S:\Pricing\Performance Templates\2005 Q3\Performance Templates\ The spreadsheet is called "Partner 1.xls" and the worksheet is called "Review - Creditor" and I want to look at cell A1. How would I write this? Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect Formula
It looks at though you want to access a closed workbook, doesn't work with
INDIRECT. Try Laurent Longre's MOREFUNC utility. It is free, and you can find it at http://xcell05.free.fr/ -- HTH RP (remove nothere from the email address if mailing direct) "fullers" wrote in message ... I want to use the indirect formula so I can put the directory path in a cell and link to it. I want to link to a a spreadsheet located here - S:\Pricing\Performance Templates\2005 Q3\Performance Templates\ The spreadsheet is called "Partner 1.xls" and the worksheet is called "Review - Creditor" and I want to look at cell A1. How would I write this? Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect Formula
Thanks for that.
Have just tried using the formula indirect.ext as follows: =INDIRECT.EXT("'S:\Pricing\Performance Templates\2005 Q3\Performance Templates\[Partner 1.xls]Review - Creditor'!A1") unfortunately it doesn't seem to work. Anything obvious you can spot that I am doing wrong with the formula? Thanks "Bob Phillips" wrote: It looks at though you want to access a closed workbook, doesn't work with INDIRECT. Try Laurent Longre's MOREFUNC utility. It is free, and you can find it at http://xcell05.free.fr/ -- HTH RP (remove nothere from the email address if mailing direct) "fullers" wrote in message ... I want to use the indirect formula so I can put the directory path in a cell and link to it. I want to link to a a spreadsheet located here - S:\Pricing\Performance Templates\2005 Q3\Performance Templates\ The spreadsheet is called "Partner 1.xls" and the worksheet is called "Review - Creditor" and I want to look at cell A1. How would I write this? Thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect Formula
Sorry, I probably can't help as I don't use that utility, I have a custom
utility that I use. -- HTH RP (remove nothere from the email address if mailing direct) "fullers" wrote in message ... Thanks for that. Have just tried using the formula indirect.ext as follows: =INDIRECT.EXT("'S:\Pricing\Performance Templates\2005 Q3\Performance Templates\[Partner 1.xls]Review - Creditor'!A1") unfortunately it doesn't seem to work. Anything obvious you can spot that I am doing wrong with the formula? Thanks "Bob Phillips" wrote: It looks at though you want to access a closed workbook, doesn't work with INDIRECT. Try Laurent Longre's MOREFUNC utility. It is free, and you can find it at http://xcell05.free.fr/ -- HTH RP (remove nothere from the email address if mailing direct) "fullers" wrote in message ... I want to use the indirect formula so I can put the directory path in a cell and link to it. I want to link to a a spreadsheet located here - S:\Pricing\Performance Templates\2005 Q3\Performance Templates\ The spreadsheet is called "Partner 1.xls" and the worksheet is called "Review - Creditor" and I want to look at cell A1. How would I write this? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide formula | Excel Worksheet Functions | |||
Indirect used in an array formula | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Indirect references in a linked formula | Excel Worksheet Functions |