#1   Report Post  
Old November 25th 05, 11:19 AM posted to microsoft.public.excel.worksheet.functions
fullers
 
Posts: n/a
Default 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   Report Post  
Old November 25th 05, 11:35 AM posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Old November 25th 05, 12:12 PM posted to microsoft.public.excel.worksheet.functions
fullers
 
Posts: n/a
Default 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   Report Post  
Old November 25th 05, 01:08 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide formula skateblade Excel Worksheet Functions 10 October 15th 05 08:36 PM
Indirect used in an array formula Werner Rohrmoser Excel Worksheet Functions 3 July 23rd 05 04:03 PM
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM
Indirect references in a linked formula Markshnier Excel Worksheet Functions 0 November 15th 04 03:36 AM


All times are GMT +1. The time now is 01:31 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017