Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data connections | Excel Discussion (Misc queries) | |||
How do I permanently remove external data connections? | Excel Worksheet Functions | |||
Data Connections | Excel Worksheet Functions | |||
Data connections | Excel Discussion (Misc queries) | |||
Lost External Data Connections | Excel Discussion (Misc queries) |