Update Links yes or no?

[brooksres]

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?

 

[Richard Schollar]

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

 

[brooksres]

Bugger was in the defined names, THANK YOU VERY VERY MUCH!!!