the links from the source and destination excel workbooks are refreshed when
the destination workbook is opened. if somebody opens the source and saves
it on a different pc, is there anyway to refresh the data in the destination
without closing and reopening the workbook?

i know the links are dynamic when both are open on the same pc.

--


Gary

i found through the edit-links menu option, i can update a source, but
there must be a way to update all of the links to the other workbooks, isn't
there?

--


Gary


"Gary Keramidas" wrote in message
...
the links from the source and destination excel workbooks are refreshed
when the destination workbook is opened. if somebody opens the source and
saves it on a different pc, is there anyway to refresh the data in the
destination without closing and reopening the workbook?

i know the links are dynamic when both are open on the same pc.

--


Gary