Reoccurring Edit Links Error

I have built a workbook that has links to a worksheet in another workbook in
the same folder. Recently, every time I update my links, I receive a pop up
that states: "This workbook contains one or more links that cannot be
updated." However, when I click on "Edit Links", I only have links to one
source worksheet (the worksheet previously mentioned) with Status being OK.
Since status is OK I do not know why I continually receive this error. I
have checked all buttons and names and they do not appear to have links to
other sources.

Does anyone know why this message is continually appearing? Is it possible
to turn this message off?

Thanks for any direction!
Jeff

Bill Manville's FindLink addin may help you find the hard to find links:
http://www.oaltd.co.uk/MVP/Default.htm

Spyder wrote:
>
> I have built a workbook that has links to a worksheet in another workbook in
> the same folder. Recently, every time I update my links, I receive a pop up
> that states: "This workbook contains one or more links that cannot be
> updated." However, when I click on "Edit Links", I only have links to one
> source worksheet (the worksheet previously mentioned) with Status being OK.
> Since status is OK I do not know why I continually receive this error. I
> have checked all buttons and names and they do not appear to have links to
> other sources.
>
> Does anyone know why this message is continually appearing? Is it possible
> to turn this message off?
>
> Thanks for any direction!
> Jeff

--

Dave Peterson

Thank you so much for that tip! I was pullling my hair out all morning and that utility totally fixed my problem. I had added a worksheet to my workbook and linked it to another workbook. When I removed the sheet, my original file insisted that it find some Register.Dlink from the other workbook and absolutely would not go away--until now. Awesome!

Jean

Thanks Dave, I have used FindLink, but it has not helped me with this issue.
I still get the pop-up message. Is there anyway to turn off the "Edit Links"
message?


"Dave Peterson" wrote:

> Bill Manville's FindLink addin may help you find the hard to find links:
> http://www.oaltd.co.uk/MVP/Default.htm
>
> Spyder wrote:
> >
> > I have built a workbook that has links to a worksheet in another workbook in
> > the same folder. Recently, every time I update my links, I receive a pop up
> > that states: "This workbook contains one or more links that cannot be
> > updated." However, when I click on "Edit Links", I only have links to one
> > source worksheet (the worksheet previously mentioned) with Status being OK.
> > Since status is OK I do not know why I continually receive this error. I
> > have checked all buttons and names and they do not appear to have links to
> > other sources.
> >
> > Does anyone know why this message is continually appearing? Is it possible
> > to turn this message off?
> >
> > Thanks for any direction!
> > Jeff
>
> --
>
> Dave Peterson
>

If you answer no to the "do you want to update links" question, do you still get
that message?



Spyder wrote:
>
> Thanks Dave, I have used FindLink, but it has not helped me with this issue.
> I still get the pop-up message. Is there anyway to turn off the "Edit Links"
> message?
>
> "Dave Peterson" wrote:
>
> > Bill Manville's FindLink addin may help you find the hard to find links:
> > http://www.oaltd.co.uk/MVP/Default.htm
> >
> > Spyder wrote:
> > >
> > > I have built a workbook that has links to a worksheet in another workbook in
> > > the same folder. Recently, every time I update my links, I receive a pop up
> > > that states: "This workbook contains one or more links that cannot be
> > > updated." However, when I click on "Edit Links", I only have links to one
> > > source worksheet (the worksheet previously mentioned) with Status being OK.
> > > Since status is OK I do not know why I continually receive this error. I
> > > have checked all buttons and names and they do not appear to have links to
> > > other sources.
> > >
> > > Does anyone know why this message is continually appearing? Is it possible
> > > to turn this message off?
> > >
> > > Thanks for any direction!
> > > Jeff
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

I've never seen Bill Manville's program fail to find the link. So I'm not sure
what the answer will be.

Dave Peterson wrote:
>
> If you answer no to the "do you want to update links" question, do you still get
> that message?
>
> Spyder wrote:
> >
> > Thanks Dave, I have used FindLink, but it has not helped me with this issue.
> > I still get the pop-up message. Is there anyway to turn off the "Edit Links"
> > message?
> >
> > "Dave Peterson" wrote:
> >
> > > Bill Manville's FindLink addin may help you find the hard to find links:
> > > http://www.oaltd.co.uk/MVP/Default.htm
> > >
> > > Spyder wrote:
> > > >
> > > > I have built a workbook that has links to a worksheet in another workbook in
> > > > the same folder. Recently, every time I update my links, I receive a pop up
> > > > that states: "This workbook contains one or more links that cannot be
> > > > updated." However, when I click on "Edit Links", I only have links to one
> > > > source worksheet (the worksheet previously mentioned) with Status being OK.
> > > > Since status is OK I do not know why I continually receive this error. I
> > > > have checked all buttons and names and they do not appear to have links to
> > > > other sources.
> > > >
> > > > Does anyone know why this message is continually appearing? Is it possible
> > > > to turn this message off?
> > > >
> > > > Thanks for any direction!
> > > > Jeff
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson

--

Dave Peterson

Unfortuantely, we will have to update the links when the workbook is open to
pull the most current information. I agree with you on Bill's program. It
is very likely that the program is finding all of the links, but for some
reason Excel "thinks" one of the links is broken, and sends up the "Edit
Links" error message every time even though status always = OK. That is why,
if possible, I am wondering if there is any way to turn off that "Edit Links"
pop-up? OR if there are other reasons an OK link will pop-up the "Edit
Links" message, maybe I should look into those.

Thanks for any direction!

"Dave Peterson" wrote:

> I've never seen Bill Manville's program fail to find the link. So I'm not sure
> what the answer will be.
>
> Dave Peterson wrote:
> >
> > If you answer no to the "do you want to update links" question, do you still get
> > that message?
> >
> > Spyder wrote:
> > >
> > > Thanks Dave, I have used FindLink, but it has not helped me with this issue.
> > > I still get the pop-up message. Is there anyway to turn off the "Edit Links"
> > > message?
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > Bill Manville's FindLink addin may help you find the hard to find links:
> > > > http://www.oaltd.co.uk/MVP/Default.htm
> > > >
> > > > Spyder wrote:
> > > > >
> > > > > I have built a workbook that has links to a worksheet in another workbook in
> > > > > the same folder. Recently, every time I update my links, I receive a pop up
> > > > > that states: "This workbook contains one or more links that cannot be
> > > > > updated." However, when I click on "Edit Links", I only have links to one
> > > > > source worksheet (the worksheet previously mentioned) with Status being OK.
> > > > > Since status is OK I do not know why I continually receive this error. I
> > > > > have checked all buttons and names and they do not appear to have links to
> > > > > other sources.
> > > > >
> > > > > Does anyone know why this message is continually appearing? Is it possible
> > > > > to turn this message off?
> > > > >
> > > > > Thanks for any direction!
> > > > > Jeff
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
>
> --
>
> Dave Peterson
>

Not that I know.

Maybe someone else can jump in.

Spyder wrote:
>
> Unfortuantely, we will have to update the links when the workbook is open to
> pull the most current information. I agree with you on Bill's program. It
> is very likely that the program is finding all of the links, but for some
> reason Excel "thinks" one of the links is broken, and sends up the "Edit
> Links" error message every time even though status always = OK. That is why,
> if possible, I am wondering if there is any way to turn off that "Edit Links"
> pop-up? OR if there are other reasons an OK link will pop-up the "Edit
> Links" message, maybe I should look into those.
>
> Thanks for any direction!
>
> "Dave Peterson" wrote:
>
> > I've never seen Bill Manville's program fail to find the link. So I'm not sure
> > what the answer will be.
> >
> > Dave Peterson wrote:
> > >
> > > If you answer no to the "do you want to update links" question, do you still get
> > > that message?
> > >
> > > Spyder wrote:
> > > >
> > > > Thanks Dave, I have used FindLink, but it has not helped me with this issue.
> > > > I still get the pop-up message. Is there anyway to turn off the "Edit Links"
> > > > message?
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > Bill Manville's FindLink addin may help you find the hard to find links:
> > > > > http://www.oaltd.co.uk/MVP/Default.htm
> > > > >
> > > > > Spyder wrote:
> > > > > >
> > > > > > I have built a workbook that has links to a worksheet in another workbook in
> > > > > > the same folder. Recently, every time I update my links, I receive a pop up
> > > > > > that states: "This workbook contains one or more links that cannot be
> > > > > > updated." However, when I click on "Edit Links", I only have links to one
> > > > > > source worksheet (the worksheet previously mentioned) with Status being OK.
> > > > > > Since status is OK I do not know why I continually receive this error. I
> > > > > > have checked all buttons and names and they do not appear to have links to
> > > > > > other sources.
> > > > > >
> > > > > > Does anyone know why this message is continually appearing? Is it possible
> > > > > > to turn this message off?
> > > > > >
> > > > > > Thanks for any direction!
> > > > > > Jeff
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson