Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting automatic links
Hello,
When i open my workbook, it asks me if i want to update automatic external links - i thought i'd deleted them all! How do i delete them? (i've tried edit/links but can't see how to delete them from there.....) Many Thanks -- kelly m johnson Great Britain |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting automatic links
To delete them, you must first locate them, which may not be easy if the
document is large. Look at columns and rows that have formulas. If you find them, you can change the cell(s) content to a value by selecting the cell(s) and pressing Ctrl+Shift+F9. "Kelly 1st" wrote in message ... Hello, When i open my workbook, it asks me if i want to update automatic external links - i thought i'd deleted them all! How do i delete them? (i've tried edit/links but can't see how to delete them from there.....) Many Thanks -- kelly m johnson Great Britain |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting automatic links | Excel Discussion (Misc queries) | |||
Excel links & inserting/deleting rows | Excel Discussion (Misc queries) | |||
Deleting links to other spreadsheets | Excel Worksheet Functions | |||
deleting internet links | Excel Worksheet Functions | |||
Deleting Links | Links and Linking in Excel |