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.

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

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" wrote
in message ...

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

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

Perhaps it is a phantom link:

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

--
raypayett

-----------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...fo&userid=2956
View this thread: http://www.excelforum.com/showthread.php?threadid=56595

PERFECT! it was a phantom link described in #2. it was a named range.
thanks!
"raypayette" wrote
in message ...

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