try this...

select
option-advanced-when calculating this workbook- save external links
values

if you dont save the external values, the excel would need to get the
values from the external links everytime, thus getting the most
updtaed data automatically