ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   edit links (https://www.excelbanter.com/excel-programming/368634-edit-links.html)

mike allen[_2_]

edit links
 
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[_23_]

edit links
 

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


mike allen[_2_]

edit links
 
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




Dave Peterson

edit links
 
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[_26_]

edit links
 

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


mike allen[_2_]

edit links
 
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





All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com