Rob Smith wrote:
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?


It would help if we could see the macro.
If you cut and paste to/from the cell or delete the cell then you would
get this effect.

If such an operation is inevitable then you could change the formula to
=INDIRECT("Data!$B$1")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup