Changing hyperlinks in Excel Worksheet

[Colona]

I have to work on a very large Excel workbook in which
most of the cells are linked to another Excel file by
hyperlinks. I have to update the file once a month by
changing the hyperlinks cell by cell to a updated source
file. It's so time-consuming. I am sure there must be a
smarter way to do it. I believe that Macro may do but I
am not good at macro at all. I appreciate if anyone could
give me any sort of suggestions.

Thanks.

Colona

 

[rob]

Maybe someone can answer your question exactly, but as
another approach.

In the spreadsheet you change each month set a cell aside
for the hyperlink. Use the "HYPERLINK" function to copy
that hyperlink to all other cells (you'll only do this
once). When the hyperlink needs to be changed (next
month) simply edit the single cell that all the other
cells refer to.

Regards

 

[Andy]

Colona

Can't you use Find/Replace?

Andy.