Updating linked data

[martk]

Hi Guys,

I need some help please.

Using Excel 97, I have (via a home network) Excel "File 1" on my PC and
Excel "File 2" on a 2nd networked PC.

Both files are open on their respective PCs. "File 2" has data that is
updating continually via a DDE setup on that PC.

"File 1" has cells that link to some of the cells in "File 2".

I have a macro that updates the links when I activate it. However,
the links only update to the last Saved version of "File 2".
How can I get the macro in "File 1" to Save the "File2" before updating
the links, so that I get the latest data.

Many thanks for any assistance.

martk

 

[Dave Peterson]

If both files are open in the same instance of excel, then the updates will be
immediate.

But that's not your situation.

Maybe you could have an ontime macro run that saves the "file 2" workbook.

Chip Pearson has some nice instructions at:
http://www.cpearson.com/excel/ontime.htm