how can I stop an excel cell being calculated
 

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?

how can I stop an excel cell being calculated
 

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?