Link behavior with changing data set


F

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
 
Ad

Advertisements

F

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
 
Ad

Advertisements

D

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 ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top