External data connections

[CellShocked]

Hey guys,

Where do I look to manage external data links or GET RID OF THEM!!!?

I hate how cut and paste from elsewhere links to elsewhere when all one
wants is the code, not the data links.

I know where name manager is, but where do I edit and delete external
links from?

 

[smartin]

Hey guys,

Where do I look to manage external data links or GET RID OF THEM!!!?

I hate how cut and paste from elsewhere links to elsewhere when all one
wants is the code, not the data links.

I know where name manager is, but where do I edit and delete external
links from?

In E2003 and earlier, Edit | Links | Break Link

In E2007 I think it's Office button | Prepare | Edit Links | Break Link

To avoid creating links in the first place, do not just copy & paste.
Rather, copy, then paste special | values.

 

[CellShocked]

In E2003 and earlier, Edit | Links | Break Link

In E2007 I think it's Office button | Prepare | Edit Links | Break Link

To avoid creating links in the first place, do not just copy & paste.
Rather, copy, then paste special | values.

I am aware of that, and I did not merely copy a cell. I copied an
entire sheet or workbook. They should still be readily manageable.
No, one cannot paste special on entire sheet or workbook move operations.