Need macro to update cell that linked to another program

[loveguy1977]

Dear Sir,


I'm linking cells a live trading program to get prices. If internet discounted, and internet back after 3 mintue, cell will stop updated until I click and enter all formula in the cells or close the file and reopen it then live price will work again in excel.


Therefore, I need your help to update cells when internet back
or need a macro for each ocell in range to retype the formula in Odell


Thank you very much please help me please

[snb]

Dear madam,

In this part of the world women are allowed to use Internet.