software

I have a workbook which is linked to another. When I open the Destination
book, the Update Links box appears asking if I would like to update. That is
all fine and well, and I know about linking etc. What I don't know is how to
see what the updates are. Is there somehwere in Excel that will show me what
updates have been made when I select the Update button?

Thanks in advance,

If you click on EDIT in the menu and select LINKS it will tell what files
you're linked to, and if you click on TOOLS, select OPTIONS and click on the
VIEW tab, in the bottom segment of the dialog box in Window Options, click
the FORMULAS check box to display formulas in cells instead of their results,
this will make it easier to locate your linked cells.

You could then change the font color to make them easy to spot.
--
Kevin Backmannquot;Greenbackquot; wrote:

gt; I have a workbook which is linked to another. When I open the Destination
gt; book, the Update Links box appears asking if I would like to update. That is
gt; all fine and well, and I know about linking etc. What I don't know is how to
gt; see what the updates are. Is there somehwere in Excel that will show me what
gt; updates have been made when I select the Update button?
gt;
gt; Thanks in advance,

Kevin,
Thanks for your reply, this is certainly something that will help me.
However, what I need to know is how do I tell if there has been an update
made, ie, if I have 20 cells which are linked to another workbook, say
workbook 1, and my destination workbook is say workbook2, whenever a change
has been made in workbook 1 and saved, when I open workbook 2 the message box
will ask me if I want to update. If I click on update, workbook 2 will check
the changes made in workbook 1 and make the changes. Now,there may be only 10
changes made...how do I see what changes have been made? Is there something I
can go to in workbook 2 to show me which cells have been updated with the new
data?

Thanks again
quot;Kevin Bquot; wrote:

gt; If you click on EDIT in the menu and select LINKS it will tell what files
gt; you're linked to, and if you click on TOOLS, select OPTIONS and click on the
gt; VIEW tab, in the bottom segment of the dialog box in Window Options, click
gt; the FORMULAS check box to display formulas in cells instead of their results,
gt; this will make it easier to locate your linked cells.
gt;
gt; You could then change the font color to make them easy to spot.
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;Greenbackquot; wrote:
gt;
gt; gt; I have a workbook which is linked to another. When I open the Destination
gt; gt; book, the Update Links box appears asking if I would like to update. That is
gt; gt; all fine and well, and I know about linking etc. What I don't know is how to
gt; gt; see what the updates are. Is there somehwere in Excel that will show me what
gt; gt; updates have been made when I select the Update button?
gt; gt;
gt; gt; Thanks in advance,

While you can trap a calculation event in a worksheet, I don' t know of any
method captures a change of value in a cell. To the best of my knowledge a
changed value in a formula does not trigger change event. Aside from pre and
post calcuation comparison on a cell by cell basis I can't think of any wayt
to accomplish what you're trying to do.
--
Kevin Backmannquot;Greenbackquot; wrote:

gt; Kevin,
gt; Thanks for your reply, this is certainly something that will help me.
gt; However, what I need to know is how do I tell if there has been an update
gt; made, ie, if I have 20 cells which are linked to another workbook, say
gt; workbook 1, and my destination workbook is say workbook2, whenever a change
gt; has been made in workbook 1 and saved, when I open workbook 2 the message box
gt; will ask me if I want to update. If I click on update, workbook 2 will check
gt; the changes made in workbook 1 and make the changes. Now,there may be only 10
gt; changes made...how do I see what changes have been made? Is there something I
gt; can go to in workbook 2 to show me which cells have been updated with the new
gt; data?
gt;
gt; Thanks again
gt; quot;Kevin Bquot; wrote:
gt;
gt; gt; If you click on EDIT in the menu and select LINKS it will tell what files
gt; gt; you're linked to, and if you click on TOOLS, select OPTIONS and click on the
gt; gt; VIEW tab, in the bottom segment of the dialog box in Window Options, click
gt; gt; the FORMULAS check box to display formulas in cells instead of their results,
gt; gt; this will make it easier to locate your linked cells.
gt; gt;
gt; gt; You could then change the font color to make them easy to spot.
gt; gt; --
gt; gt; Kevin Backmann
gt; gt;
gt; gt;
gt; gt; quot;Greenbackquot; wrote:
gt; gt;
gt; gt; gt; I have a workbook which is linked to another. When I open the Destination
gt; gt; gt; book, the Update Links box appears asking if I would like to update. That is
gt; gt; gt; all fine and well, and I know about linking etc. What I don't know is how to
gt; gt; gt; see what the updates are. Is there somehwere in Excel that will show me what
gt; gt; gt; updates have been made when I select the Update button?
gt; gt; gt;
gt; gt; gt; Thanks in advance,


Would Track Changes work?--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=507612Thanks anyway, much appreciated

quot;Kevin Bquot; wrote:

gt; While you can trap a calculation event in a worksheet, I don' t know of any
gt; method captures a change of value in a cell. To the best of my knowledge a
gt; changed value in a formula does not trigger change event. Aside from pre and
gt; post calcuation comparison on a cell by cell basis I can't think of any wayt
gt; to accomplish what you're trying to do.
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;Greenbackquot; wrote:
gt;
gt; gt; Kevin,
gt; gt; Thanks for your reply, this is certainly something that will help me.
gt; gt; However, what I need to know is how do I tell if there has been an update
gt; gt; made, ie, if I have 20 cells which are linked to another workbook, say
gt; gt; workbook 1, and my destination workbook is say workbook2, whenever a change
gt; gt; has been made in workbook 1 and saved, when I open workbook 2 the message box
gt; gt; will ask me if I want to update. If I click on update, workbook 2 will check
gt; gt; the changes made in workbook 1 and make the changes. Now,there may be only 10
gt; gt; changes made...how do I see what changes have been made? Is there something I
gt; gt; can go to in workbook 2 to show me which cells have been updated with the new
gt; gt; data?
gt; gt;
gt; gt; Thanks again
gt; gt; quot;Kevin Bquot; wrote:
gt; gt;
gt; gt; gt; If you click on EDIT in the menu and select LINKS it will tell what files
gt; gt; gt; you're linked to, and if you click on TOOLS, select OPTIONS and click on the
gt; gt; gt; VIEW tab, in the bottom segment of the dialog box in Window Options, click
gt; gt; gt; the FORMULAS check box to display formulas in cells instead of their results,
gt; gt; gt; this will make it easier to locate your linked cells.
gt; gt; gt;
gt; gt; gt; You could then change the font color to make them easy to spot.
gt; gt; gt; --
gt; gt; gt; Kevin Backmann
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Greenbackquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a workbook which is linked to another. When I open the Destination
gt; gt; gt; gt; book, the Update Links box appears asking if I would like to update. That is
gt; gt; gt; gt; all fine and well, and I know about linking etc. What I don't know is how to
gt; gt; gt; gt; see what the updates are. Is there somehwere in Excel that will show me what
gt; gt; gt; gt; updates have been made when I select the Update button?
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks in advance,