how can you see what is updated when linking workbooks
 

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,

how can you see what is updated when linking workbooks
 

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 Backmann


"Greenback" wrote:

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,

how can you see what is updated when linking workbooks
 

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
"Kevin B" wrote:

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 Backmann


"Greenback" wrote:

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,

how can you see what is updated when linking workbooks
 

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 Backmann


"Greenback" wrote:

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
"Kevin B" wrote:

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 Backmann


"Greenback" wrote:

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,

how can you see what is updated when linking workbooks
 

Would Track Changes work?


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=507612

how can you see what is updated when linking workbooks
 

Thanks anyway, much appreciated

"Kevin B" wrote:

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 Backmann


"Greenback" wrote:

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
"Kevin B" wrote:

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 Backmann


"Greenback" wrote:

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,