Can we update links automatically somehow after making a copy of a sheet with links?

Is there a way to do this that is not manual? Knowing the power of XL2K, it
seemed wrong to me, somehow, that each time my supervisor makes a copy of a
sheet, she has to fix the links manually. Any help would be greatly
appreciated. I have a colleague who is working in this massive workbook at
present, and she's daunted at all the new sheets to add that will require
all this manual editing.

Thank you! :oD

You don't indicate exactly what you have to change,
sheetnames, workbook names. Formulas or links
that get changed would help.

If you are copying more than one sheet that is related
to other sheets, you shoud copy them together as a
group.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"StargateFanFromWork" <[email protected]> wrote in message news:%23Ph5sX2%[email protected]...
> Is there a way to do this that is not manual? Knowing the power of XL2K, it
> seemed wrong to me, somehow, that each time my supervisor makes a copy of a
> sheet, she has to fix the links manually. Any help would be greatly
> appreciated. I have a colleague who is working in this massive workbook at
> present, and she's daunted at all the new sheets to add that will require
> all this manual editing.
>
> Thank you! :oD
>
>

On Wed, 7 Dec 2005 23:48:50 -0500, "David McRitchie"
<[email protected]> wrote:

>You don't indicate exactly what you have to change,
>sheetnames, workbook names. Formulas or links
>that get changed would help.

Ah, sorry. I'll ask my colleague more specifically tomorrow. Our
supervisor mentioned today that each time she makes a copy of one of
the sheets, the links never work and she has to adjust them manually.
I seem to remember her saying that she has to go in and change the
'names' and she might have said sheet name.

Excell is usu. so very good at copying everything and automatically
adjusting for relative references so my colleague and I found this
odd.

But again, I'll get more specifics tomorrow. We're running like crazy
around here. Polling day is the 23rd of January and it looks like
we're all only going to get Xmas day off and lots of overtime the rest
of the time! <g> So forgive me if I'm not 100% on the ball sometimes
<vbg>!

>If you are copying more than one sheet that is related
>to other sheets, you shoud copy them together as a
>group.

Kewl, thanks.

>---
>HTH,
>David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
>My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
>Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
>"StargateFanFromWork" <[email protected]> wrote in message news:%23Ph5sX2%[email protected]...
>> Is there a way to do this that is not manual? Knowing the power of XL2K, it
>> seemed wrong to me, somehow, that each time my supervisor makes a copy of a
>> sheet, she has to fix the links manually. Any help would be greatly
>> appreciated. I have a colleague who is working in this massive workbook at
>> present, and she's daunted at all the new sheets to add that will require
>> all this manual editing.
>>
>> Thank you! :oD
>>
>>
>

"StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
news:[email protected]...
> On Wed, 7 Dec 2005 23:48:50 -0500, "David McRitchie"
> <[email protected]> wrote:
>
> >You don't indicate exactly what you have to change,
> >sheetnames, workbook names. Formulas or links
> >that get changed would help.
>
> Ah, sorry. I'll ask my colleague more specifically tomorrow. Our
> supervisor mentioned today that each time she makes a copy of one of
> the sheets, the links never work and she has to adjust them manually.
> I seem to remember her saying that she has to go in and change the
> 'names' and she might have said sheet name.

[snip]

Okay, I just spoke with my colleague. I understand the situation better
now. I'm hoping something can be done for them.

They have four workbooks, each taking care of a category of temporary
employee (i.e., auditors, clerks, etc.). Each employee has his or her own
sheet in each workbook. This part is fine. They just need to copy any of
the sheets and put in the information for the new employee and they're done.
It's the summary sheet in each workbook that is the issue. Each one of the
four workbooks has a summary page at the front of all the other sheets.
Until they manually update it by adding new rows and manually fixing the
link to the correct sheet, the new employees do not show up. This means
going in to each cell in a new row and copying the link information as per
the other entries and then modifying to the appropriate sheet (sounds like a
blasted headache to me, esp. since we work in a govt agency that swells and
shrinks according to election events! <g>).

Is there anything I can do to help make things easier for my people at this
time for this?

Once again, thank you in advance for any help. We do appreciate it. :oD

> >---
> >HTH,
> >David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> >My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> >Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> >"StargateFanFromWork" <[email protected]> wrote in message
news:%23Ph5sX2%[email protected]...
> >> Is there a way to do this that is not manual? Knowing the power of
XL2K, it
> >> seemed wrong to me, somehow, that each time my supervisor makes a copy
of a
> >> sheet, she has to fix the links manually. Any help would be greatly
> >> appreciated. I have a colleague who is working in this massive
workbook at
> >> present, and she's daunted at all the new sheets to add that will
require
> >> all this manual editing.
> >>
> >> Thank you! :oD
> >>
> >>
> >
>

I started a new thread with a more pertinent subject line (I hope <g>).

"StargateFanFromWork" <[email protected]> wrote in message
news:[email protected]...
>
> "StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
> news:[email protected]...
> > On Wed, 7 Dec 2005 23:48:50 -0500, "David McRitchie"
> > <[email protected]> wrote:
> >
> > >You don't indicate exactly what you have to change,
> > >sheetnames, workbook names. Formulas or links
> > >that get changed would help.
> >
> > Ah, sorry. I'll ask my colleague more specifically tomorrow. Our
> > supervisor mentioned today that each time she makes a copy of one of
> > the sheets, the links never work and she has to adjust them manually.
> > I seem to remember her saying that she has to go in and change the
> > 'names' and she might have said sheet name.
>
> [snip]
>
> Okay, I just spoke with my colleague. I understand the situation better
> now. I'm hoping something can be done for them.
>
> They have four workbooks, each taking care of a category of temporary
> employee (i.e., auditors, clerks, etc.). Each employee has his or her own
> sheet in each workbook. This part is fine. They just need to copy any of
> the sheets and put in the information for the new employee and they're
done.
> It's the summary sheet in each workbook that is the issue. Each one of
the
> four workbooks has a summary page at the front of all the other sheets.
> Until they manually update it by adding new rows and manually fixing the
> link to the correct sheet, the new employees do not show up. This means
> going in to each cell in a new row and copying the link information as per
> the other entries and then modifying to the appropriate sheet (sounds like
a
> blasted headache to me, esp. since we work in a govt agency that swells
and
> shrinks according to election events! <g>).
>
> Is there anything I can do to help make things easier for my people at
this
> time for this?
>
> Once again, thank you in advance for any help. We do appreciate it. :oD
>
> > >---
> > >HTH,
> > >David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > >My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > >Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> > >
> > >"StargateFanFromWork" <[email protected]> wrote in message
> news:%23Ph5sX2%[email protected]...
> > >> Is there a way to do this that is not manual? Knowing the power of
> XL2K, it
> > >> seemed wrong to me, somehow, that each time my supervisor makes a
copy
> of a
> > >> sheet, she has to fix the links manually. Any help would be greatly
> > >> appreciated. I have a colleague who is working in this massive
> workbook at
> > >> present, and she's daunted at all the new sheets to add that will
> require
> > >> all this manual editing.
> > >>
> > >> Thank you! :oD
> > >>
> > >>
> > >
> >
>
>