View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default 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.