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

[StargateFanFromWork]

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! D

 

[David McRitchie]

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.

 

[StargateFan]

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

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

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! D

 

[StargateFanFromWork]

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. D

---
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

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! D

 

[StargateFanFromWork]

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

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. D

---
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

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