easily changing a linked reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brian.baker13@googlemail.com - 06 Jan 2008 13:11 GMT

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

Reply to this Message

Dave Peterson - 06 Jan 2008 14:51 GMT

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
>
[quoted text clipped - 7 lines]
> Much Appreciated
> Brian

Signature

Dave Peterson

Reply to this Message

brian.baker13@googlemail.com - 06 Jan 2008 18:43 GMT

On Jan 6, 1:11 pm, "brian.bake...@googlemail.com"
<brian.bake...@googlemail.com> wrote:

> Hi
>
[quoted text clipped - 7 lines]
> Much Appreciated
> Brian

Cheers Dave

Will implement tomorrow

Ta

Brian

Reply to this Message