Cut from workbook1, paste to workbook2, get automatic link in workbook1

Greetings all!

I am running Excel 2000 on a Windows XP Pro machine. I have two
workbooks. Each row in either workbook is a description of a document
with a date by which a review of that document is due (among other
things) and, in workbook1, a date by which the final review of the
document is due. This date is in the last cell of the row, and is
calculated using a formula.

If the document is *not* reviewed by the final review date, the row with
the document's entry is cut from workbook1 and pasted into workbook2.
The only difference between the two workbooks is that the last cell in
the row from workbook1 doesn't appear in workbook2.

The employee, who shall remain nameless, who cuts and pastes has, in the
past, selected cells in the row up to, but not including, the last cell
in workbook1 before pasting the data into workbook2. Then the employee
deletes the contents of the last cell that was left behind, and deletes
the empty row. What we have discovered is that Excel is creating an
automatic link between workbook1 and workbook2 when we go through this
process. We don't want that.

Is the best answer the obvious one, which I think is select the entire
row in workbook1, cut, and paste in workbook2, and ignore the last cell?
Or is it simply a matter of copying from workbook1, pasting in
workbook2, and *then* deleting the row in workbook1? Are there other
options? Is Excel *supposed* to be creating this link automatically? Can
I turn off automatic link generation?

Thanks,

Mike Bro.

Are there formulas in the cut cells which reference other cells in the
original workbook? That would explain the link creation.

If so, then a simple extra step is to copy the cells rather than cutting
them from workbook 1, and doing an Edit>Paste Special>Values into workbook2.
Then, on return to workbook 1, deleting the entire row.

ALWAYS TEST THESE PROPOSED SOLUTIONS ON A COPY OF YOUR DATA!!!


"nospam" <"mbroschi(nospam)" wrote:

> Greetings all!
>
> I am running Excel 2000 on a Windows XP Pro machine. I have two
> workbooks. Each row in either workbook is a description of a document
> with a date by which a review of that document is due (among other
> things) and, in workbook1, a date by which the final review of the
> document is due. This date is in the last cell of the row, and is
> calculated using a formula.
>
> If the document is *not* reviewed by the final review date, the row with
> the document's entry is cut from workbook1 and pasted into workbook2.
> The only difference between the two workbooks is that the last cell in
> the row from workbook1 doesn't appear in workbook2.
>
> The employee, who shall remain nameless, who cuts and pastes has, in the
> past, selected cells in the row up to, but not including, the last cell
> in workbook1 before pasting the data into workbook2. Then the employee
> deletes the contents of the last cell that was left behind, and deletes
> the empty row. What we have discovered is that Excel is creating an
> automatic link between workbook1 and workbook2 when we go through this
> process. We don't want that.
>
> Is the best answer the obvious one, which I think is select the entire
> row in workbook1, cut, and paste in workbook2, and ignore the last cell?
> Or is it simply a matter of copying from workbook1, pasting in
> workbook2, and *then* deleting the row in workbook1? Are there other
> options? Is Excel *supposed* to be creating this link automatically? Can
> I turn off automatic link generation?
>
> Thanks,
>
> Mike Bro.
>