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