Update Links yes or no?

brooksres

Board Regular
Joined
Aug 4, 2006
Messages
74
I apparently have a link to another workbook, I no doubt cut and pasted something and brought this pain upon myself.

I go to edit--> Links --> and see one link to another work book, but I can't find what in my spreadsheet is linked to that work book. I searched high and low, looked for #REF, [, ], I even searched every forumla that referenced another sheet ! So now I'm frustrated so I just want to break the link and see what happens if anything, so I clicked break links, and nothing happened. I've not clicked break links 5 times and I still have the link to this workbook.

Is there a way to find what is linked and destroy it or at least rewrite the formula so this update links BS will go away?
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

Have you cehcked your defined names? Insert>Name>Define and see if any workbook/worksheet names reference external workbooks. If unneeded, you can then delete these.

Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,109,446
Messages
5,528,802
Members
409,836
Latest member
karnasrinivas
Top