cell data protection
 

I have used a simple IF formula to pull data from another file, but once i
have pulled this information over i wont it to be saved as the actual data.
Because the file i have 'if' copied the data over from is updated every
month, and i dont wont the data on the new my sheet to be over copied each
timeits opened. How do i do this?

cell data protection
 

Before saving your worbook:
select your cell
Copy
Paste SpecialValues

HTH
--
AP

"Tim" a écrit dans le message de
...

I have used a simple IF formula to pull data from another file, but once i
have pulled this information over i wont it to be saved as the actual
data.
Because the file i have 'if' copied the data over from is updated every
month, and i dont wont the data on the new my sheet to be over copied each
timeits opened. How do i do this?