Is there a way to write a function that automatically updates a cell value, when data on the server changes?
E.g. GetStock from XLLoop web site providing stock prices. Real stock prices can change (quite quickly). It would be nice to have a function that updates Excel sheet automatically when the server receives a new quote…