Excel formulas don't work on spread sheet...

Hi,

I have a file excel file on my pc and another excel file in my google drive.
I have some formulas in drive excel file to extract some data from the file in my pc.

The problem is once i close the file on my pc the formula in drive file does not work.
I have attached an example.