easily changing a linked reference

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi

I am building a report spreadsheet that links into and pulls
information from another spreadsheet i.e LabourWk49.xls.
I have quite a lot of links into LabourWk49.xls and wondered if there
was an easy way of wholesale updating the weeks so the links can be
changed to LabourWk50.xls. Is there a macro or something that could do
this easily. I want people to be able to change the links easily.

Much Appreciated
Brian
 
You could use:
Edit|Links|Change source

or if you're very careful, you could use:
edit|replace

Make sure you give it enough information so that just the file name will be
changed.
 
Hi

I am building a report spreadsheet  that links into and pulls
information from another spreadsheet i.e LabourWk49.xls.
I have quite a lot of links into LabourWk49.xls and wondered if there
was an easy way of wholesale updating the weeks so the links can be
changed to LabourWk50.xls. Is there a macro or something that could do
this easily. I want people to be able to change the links easily.

Much Appreciated
Brian
Click to expand...

Cheers Dave

Will implement tomorrow

Ta

Brian
 
Back
Top