View Single Post
  #3   Report Post  
 
Posts: n/a
Default

Bill Manville wrote:
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


Thanks Bill. That is what I was affraid of. Each worksheet is for a
month and is linked to other spreadsheets that contain data for the
year. It's a monthly report type of workbook. Guess when it is opened
I'll just have to be patient while the entire workbook updates. Thanks
again for the input.