Referencing cells in a different file in Excel

[tsoccer63]

Hey,

I have the file "Book1" open so I don't understand why this isnt working. I do NOT want to put the full file name in because I want to be able to move the file with the results directory and have the references still work. Is my syntax wrong? I tried several changes such as taking out the 's and removing the .xls

=INDIRECT("'\\Results\[Book1.xls]Sheet1'!$A$1")

 

[xlbo]

INDIRECT will not reference a closed workbook

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[tsoccer63]

The file is open :/

 

[xlbo]

As far as I know, you must enter the full file path of the file you want to reference if you are using file path

If not, just try using the workbook name - no path.

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question