I (Excel 2003) have a WS(Data) containing a macro that updates a cell (stock
quote) via a toolbar button.

I have linked this cell to another WS cell (=Data!$B$1) which works fine if
I manually change the input.

However, when I run the Macro, which refreshes the data from the URL the
linked cell loses the link and I get (=Data!#REF!)

Can anyone help here please?

Thanks in advance ...