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

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