Link behavior with changing data set

[Fred Holmes]

Excel 2000

I would like to get rid of the following error
message.

The workbook you opened contains automatic links
to information in another workbook. Do you want
to update this workbook with changes made to the
other workbook?
. To update all linked information, click Yes.
. To keep the existing information, click No.

The desired links are _always_ to named ranges
(cells) in another worksheet in the current
workbook, never to an external workbook. The
links were originally generated/programmed to a
second worksheet in the current workbook. The
links have never been explicitly to another
workbook, and the linked formulae just contain the
range (cell) name, and do not contain any filename
of any external workbook. The problem (arose) is
generated by the fact that I need to delete the
"data" worksheet with the named ranges, and then
import, into the workbook with the "report," a
different data worksheet with the same set of
named ranges (cells), but different data (for a
different accounting period).

The data worksheet with the named ranges (cells)
is a linear dump of the Trial Balance into an
Excel worksheet/workbook by an accounting
application. The report worksheet which references
the named ranges is a financial report in an
explicitly desired format that the accounting
application doesn't seem to be able to produce.

As long as I click "no," everything is fine, but
if I give this to someone else to run, there will
be problems. Is there, perhaps, any way to auto-
answer this Msg Box with "No"?

Thanks

Fred Holmes

 

[Dave Peterson]

If excel thinks you have links, then you have links.

I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

 

[Fred Holmes]

Worked like a charm.

Apparently external links (any links that are changed) aren't removed
from the workbook when they are deleted from/as a cell formula and a
new link written into the cell/formula?

Many thanks,

Fred Holmes

 

[Dave Peterson]

Glad it worked for you.

But if you replaced the existing external link with a "link" to a worksheet in
the same workbook, then that external link is gone.

My bet is that you just missed one.

Or you had links in those hard to find places--like names, or charts or ...