update links in an individual worksheet
 

Is it possible to update links in just one worksheet of a workbook? I
have a workbook with 12 worksheets, one sheet for each month, and would
like to update the current months links instead of taking the time to
update all of the worksheets. Thanks in advance for any help.

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

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.

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