ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   deleting automatic links (https://www.excelbanter.com/excel-discussion-misc-queries/132030-deleting-automatic-links.html)

Kelly 1st

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

Richard O. Neville

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





All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com