edit links

[mike allen]

upon hitting edit--links, there appears a link to: "E:/testprogram.xls" i
want to get rid of this link. additional info:

i have no idea of what this "linked" file is, probably one i used in the
past, but he "E" drive is curious.
i have tried all the usuall stuff like edit, links, change source, but to no
avail. there are no spreadsheet formulas in the entire workbook.
there are, however, graphs throughout that may have been brought in from
another file, but all of the source data feeding the graphs are from this
workbook and the graphs work fine. any thoughts on how to rid my program of
this link? thanks.

[raypayette]

First visit:
http://support.microsoft.com/?kbid=214127

[mike allen]

i should have said that there is no result when hitting
edit--find--testprogram
so, there is no obvious link to anything. if i could find the link, or
formula that contains E:/testprogram.xls, i could easily get rid of it, but
it apparently is not there, unless you hit edit--links. it's mysterious to
me.
"raypayette" <[email protected]> wrote
in message news:[email protected]...
>
> First visit:
> http://support.microsoft.com/?kbid=214127
>
>
> --
> raypayette
>
>
> ------------------------------------------------------------------------
> raypayette's Profile:
> http://www.excelforum.com/member.php...o&userid=29569
> View this thread: http://www.excelforum.com/showthread...hreadid=565957
>

[Dave Peterson]

You have more responses in .excel

mike allen wrote:
>
> upon hitting edit--links, there appears a link to: "E:/testprogram.xls" i
> want to get rid of this link. additional info:
>
> i have no idea of what this "linked" file is, probably one i used in the
> past, but he "E" drive is curious.
> i have tried all the usuall stuff like edit, links, change source, but to no
> avail. there are no spreadsheet formulas in the entire workbook.
> there are, however, graphs throughout that may have been brought in from
> another file, but all of the source data feeding the graphs are from this
> workbook and the graphs work fine. any thoughts on how to rid my program of
> this link? thanks.

--

Dave Peterson

[raypayette]

Perhaps it is a phantom link:

http://j-walk.com/ss/excel/usertips/tip054.htm

[mike allen]

PERFECT! it was a phantom link described in #2. it was a named range.
thanks!
"raypayette" <[email protected]> wrote
in message news:[email protected]...
>
> Perhaps it is a phantom link:
>
> http://j-walk.com/ss/excel/usertips/tip054.htm
>
>
> --
> raypayette
>
>
> ------------------------------------------------------------------------
> raypayette's Profile:
> http://www.excelforum.com/member.php...o&userid=29569
> View this thread: http://www.excelforum.com/showthread...hreadid=565957
>