how to suppress "update links" message for workbook with no links?

[Rich]

Hello,

I created a simple workbook that pulls data from a sql server db (using ADO)
and copies this data to a sheet. Then I have a 2nd sheet - the presentation
sheet where I have formulas that reference the data sheet. There are no
links in this workbook, but all of a sudden I am getting a message to update
the links. I vaguely remember something about searching for a bracket [
which indicates a link. How can I clear this - or suppress the link message?

Thanks.
Rich

[Rich]

I think I figured out what the problem is: I made a backup workbook with my
data and formulas. I had to re-copy stuff from that workbook, so that is how
the links got created. There were hundreds of them. Now I have to start
from scratch and remove all the stuff.

"Rich" wrote:

> Hello,
>
> I created a simple workbook that pulls data from a sql server db (using ADO)
> and copies this data to a sheet. Then I have a 2nd sheet - the presentation
> sheet where I have formulas that reference the data sheet. There are no
> links in this workbook, but all of a sudden I am getting a message to update
> the links. I vaguely remember something about searching for a bracket [
> which indicates a link. How can I clear this - or suppress the link message?
>
> Thanks.
> Rich

[Bob Phillips]

Bill Manville has written a utility, FindLink, for working with links. You
can get it at http://www.oaltd.co.uk/MVP/Default.htm. That might help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rich" <[email protected]> wrote in message
news:[email protected]...
> I think I figured out what the problem is: I made a backup workbook with
my
> data and formulas. I had to re-copy stuff from that workbook, so that is
how
> the links got created. There were hundreds of them. Now I have to start
> from scratch and remove all the stuff.
>
> "Rich" wrote:
>
> > Hello,
> >
> > I created a simple workbook that pulls data from a sql server db (using
ADO)
> > and copies this data to a sheet. Then I have a 2nd sheet - the
presentation
> > sheet where I have formulas that reference the data sheet. There are no
> > links in this workbook, but all of a sudden I am getting a message to
update
> > the links. I vaguely remember something about searching for a bracket [
> > which indicates a link. How can I clear this - or suppress the link
message?
> >
> > Thanks.
> > Rich