Is it possible to update links in just one worksheet of a workbook?
Not as far as I know.
If the links are all in the same sheet, say "July" then you could do
Edit / Replace / July [with] July / Replace All
which I think would update the formulas
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|