Update links question?????????? I'm baffled!!!

  • Thread starter Thread starter Sophie
  • Start date Start date
S

Sophie

I have produced a file on excel. On this file I have not set up any links at
all. But all of the sudden when I open the file it asks if I wish to update
the links.
Why has this happened!!!!!!!!?????? Any ideas?
 
Sophie,

Somehow a link has managed to get in. To clear it click

Edit|Links

and you get a popup with links to external sources and you have choices and
I suspect the one you want is 'Break Links'

Mike
 
Thanks Mike I did that but some of my formulas dont work. I get #NAME?
indicated in the cell and when I redo the formula it still gives me #NAME?
 
Probably you have a name (Insert / Name / Define) linked at another file. You
would you be able to break the link (Edit / Links) unless you change where
the name is pointing to. Good luck.
 
You must log in or register to reply here.

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

Linked Excel Files - Shared Server 2
Nexus 7 Update 3
update links question 2
Linkage problem 1
Can't stop Excel 2007 from updating links 2
Why doesn't Excel 2007 automatically update links in Trusted Files 0
Excel 2003 - Don't Update Issue 4
Update Files Automatically with Links 1

Back
Top