External data connections
 

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?

External data connections
 

CellShocked wrote:
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.

External data connections
 

On Sat, 24 Oct 2009 20:49:33 -0400, smartin wrote:

CellShocked wrote:
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.


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.