how can I stop an excel cell being calculated

[aslmr]

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?

[Sasa Stankovic]

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" <aslmr@discussions.microsoft.com> wrote in message
news:21352D0B-9AC1-4FCE-AB9F-C9214718DBA4@microsoft.com...
>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?