I am pulling data in from another Excel file using the "indirekt" (German
name)function, this only works as long as the other file is open.

How can I save the data extracted from that file when the file is not open?

can I freeze the data with a function? not copying and inserting the value!

or only recalculate that cell when the other file is open?

if you select data from another workbbok then you have one good thing to do:
collect data from another workbook - with your function
Edit - Go To
Special...
Current Region
Copy
Edit - Paste Special
Values
This way all data will be saved in this file and WILL NOT link to source
workbook.
I hope this will help you
"aslmr" wrote in message
...
I am pulling data in from another Excel file using the "indirekt" (German
name)function, this only works as long as the other file is open.

How can I save the data extracted from that file when the file is not
open?

can I freeze the data with a function? not copying and inserting the
value!

or only recalculate that cell when the other file is open?