| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update links question?????????? I'm baffled!!!
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Update links question?????????? I'm baffled!!!
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 "Sophie" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Update links question?????????? I'm baffled!!!
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? -- Sophie "Mike H" wrote: 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 "Sophie" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Update links question?????????? I'm baffled!!!
I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm Sophie wrote: 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Update links question?????????? I'm baffled!!!
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. "Sophie" wrote: 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? -- Sophie "Mike H" wrote: 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 "Sophie" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not really new but baffled. Where do my posts disappear to?? | New Users to Excel | |||
| Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
| update links question | Excel Discussion (Misc queries) | |||
| Completely baffled on what should be simple | Excel Discussion (Misc queries) | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
Linear Mode
