Reference to values disappear after closing file

B

Bret Bernever

When I use this formula in a worksheet:

=INDIRECT(ADDRESS(COLUMN()+5,4,,,"C:\Temp\[januari_2010.XLS]sheet1"))

The values disappear after closing the file januari_2010.xls and the
error #REF! appears.
Apparently this formula can't keep the reference when the file is closed

But when I use this formula in a worksheet:

='C:\Temp\[januari_2010.XLS]sheet1'!$C$10

the value stay visible even after closing the file januari_2010.xls. How
is that possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word OLE to check spelling in text box 1
Use external file variable in formula 2
Problem with SET & REF function 0
Indirect formula errors if file is closed 1
closing another file by code causes failure to run workbook activate event 2
Original read only file not closing 0
Please help! Cannot open pivotTable source file.... 2
Userform Save data To Worksheet & File 1

Top