External data connections

  • Thread starter Thread starter CellShocked
  • Start date Start date
C

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?
 
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.
Click to expand...


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.
 
Back
Top