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?