Thanks for the replies. To be more specific, the sheets in the workbook
contain names for a schedule. Each sheet covers a one week period. Each sheet
is linked to the one before it (Paste Special/Paste Link) so that if a name
changes in any particular week, it will be changed in all weeks that follow.
So the formula in each cell is merely an instruction to place the same name
in the same cell reference on all sheets that follow ie ='Zone Nov
20-26'!D26. Any new sheets that are added automatically insert before sheet
#1 so I have to move them to the end to keep them in order. When I move the
new sheet to the end, the links between the other sheets quit working. Giving
Excel a kickstart using the Find/Replace = trick fixes the problem until I
add another sheet. So now I can fix the damage, but I'd like to stop it from
occuring in the first place.

"Dave Peterson" wrote:

Maybe you could post the formula that breaks when you move the worksheet.

Post the before and after versions.

Doug T wrote:

I'll do my best to make this short.
I have workbook with a number of worksheets that interact with each other
through links. The idea is that if I change the information contained in a
cell on one sheet, the linked info on another sheet will also change. I set
this up using Paste Special/Paste Link.
So, to explain the problem, say I have 4 sheets of data. I create a 5th
sheet by copying a template I have set up, and then Paste Special/Paste Link
data from any or all of the original 4 to the new 5th sheet. Everything works
fine on the 5th sheet as long as I don't move it. Changes I make in the
linked sheets are reflected on the 5th sheet as intended. Then, when I drag
the new sheet (the tab) to another location in the workbook, say between 2
and 3, the links to the new sheet quit working and some of the others quit as
well. I have tried this on 3 different computers and the result is the same.
Any ideas??

--

Dave Peterson