I wrote:
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


I meant:
If the links are all *to* the same sheet, say "July" then you could do
Edit / Replace / July [with] July / Replace All
which I think would update the formulas

Sorry!

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