Prev: Convert to negative numbers in whole worksheet
Next: Extract numbers from a string of text
From: Nadine on 27 May 2010 16:44
I have a workbook that asks me this when I open it. I cannot find the link
that is pointing to another workbook. Does anyone know an easy way to find
this? Thanks so much.

From: Dave Peterson on 27 May 2010 17:00
I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Nadine wrote:
>
> I have a workbook that asks me this when I open it. I cannot find the link
> that is pointing to another workbook. Does anyone know an easy way to find
> this? Thanks so much.

--

Dave Peterson
From: Nadine on 27 May 2010 17:01
Thanks so much!!!

"FSt1" wrote:

> hi
> do a find. links are usually formulas that have brackets something like
> =[MyBook1.xls]Sheet1!$A$1
> so in the find box search for either a [ or ].
> in the within box, check workbook
> in the look in box, check formulas
> click find all.
>
> also you might try....
> 03 or later...on the menu bar>edit>links. you cant' delete the link and i
> don't think it displays but you can choose to show the message or not. click
> startup prompt.
> 07.
> data tab>edit links.
>
>
> "Nadine" wrote:
>
> > I have a workbook that asks me this when I open it. I cannot find the link
> > that is pointing to another workbook. Does anyone know an easy way to find
> > this? Thanks so much.
> >
From: FSt1 on 27 May 2010 18:01
hi
do a find. links are usually formulas that have brackets something like
=[MyBook1.xls]Sheet1!$A$1
so in the find box search for either a [ or ].
in the within box, check workbook
in the look in box, check formulas
click find all.

also you might try....
03 or later...on the menu bar>edit>links. you cant' delete the link and i
don't think it displays but you can choose to show the message or not. click
startup prompt.
07.
data tab>edit links.


"Nadine" wrote:

> I have a workbook that asks me this when I open it. I cannot find the link
> that is pointing to another workbook. Does anyone know an easy way to find
> this? Thanks so much.
>
 | 
Pages: 1
Prev: Convert to negative numbers in whole worksheet
Next: Extract numbers from a string of text