how can I stop an excel cell being calculated

A

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?
 
S

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
 
Top