Unlinking workbooks

R

Rob graham

I have Excel 2000 on Win XP.

When I try to open a file a message says I have links to another workbook
and do I want to update the info or just carry on. I want to break this link
.. How do I do this?

Incidentally, one link is to a file which I have deleted and I get a message
saying that Excel - unsurprisingly - cannot find the file. I don't care, I
just want it to stop looking.

Rob Graham
 
J

Janusz Pawlinka

U¿ytkownik "Rob graham said:
I have Excel 2000 on Win XP.

When I try to open a file a message says I have links to another workbook
and do I want to update the info or just carry on. I want to break this
link . How do I do this?

Incidentally, one link is to a file which I have deleted and I get a
message saying that Excel - unsurprisingly - cannot find the file. I don't
care, I just want it to stop looking.
Click to expand...



You must find cells which have references to another workbooks and then
change/delete the links.

Very helpful at searching is key combination Ctrl+` which shows formulas
in worksheet.
 
R

Rob graham

You must find cells which have references to another workbooks and then
change/delete the links.

Very helpful at searching is key combination Ctrl+` which shows formulas
in worksheet.
Click to expand...

Thanks Janusz. I can't make out what your Ctrl+ is followed by. Is it an
apostrophe?

Rob
 
J

Janusz Pawlinka

U¿ytkownik "Rob graham said:
Thanks Janusz. I can't make out what your Ctrl+ is followed by. Is it an
apostrophe?
Click to expand...



On my keyboard it is the key on the left of "1" key and above "TAB" key.
 
D

Dave Peterson

ctrl-backquote

It's on the same key (on my USA keyboard) that the tilde (~) is on.

You could also use:
tools|Options|view tab|check formulas
(xl2003 menus)
 
Top