deleting automatic links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wits end wrt automatic linking 3
External links 1
Automatic Link Problem 3
Disconnect linked file 3
Computer Crashing 8
Why doesn't Excel 2007 automatically update links in Trusted Files 0
How can I find automatic links in an Excel-sheet? 4
Deleting / Disabling the Links 1

Back
Top