Need SOMETHING that updates a linked spreadsheet automatically

K

kpax

Hello experts,

I have two Excel 2000 spreadsheets, S1 and S2. S1 is linked to S2. Bot
reside in a Windows 2000 server.

When values in S2 are changed and saved, I need SOMETHING (a trigger
program, or script, whatever) that automatically updates values in S1
without me having to open S1 and update it myself.

Is there a solution to this problem? What could do it?

Thanks vey much for your help
 
H

Harlan Grove

kpax > said:
I have two Excel 2000 spreadsheets, S1 and S2. S1 is linked to S2. Both
reside in a Windows 2000 server.

When values in S2 are changed and saved, I need SOMETHING (a trigger,
program, or script, whatever) that automatically updates values in S1,
without me having to open S1 and update it myself.
Click to expand...
....

?

If S1 is closed, then it doesn't need the value from S2. When you open S1
after S2 has been changed and saved, then Excel will either automatically
update S1 or prompt you whether you want to update.

If you really have to have S1 updated for changes in S2, then you may need
to use a BeforeSave event handler to S2 to open S1 automatically, refresh
the links in S1 to S2, and save them both.

There is no safe/reliable way to update S1 other than opening it, refreshing
its links, and saving it. That process can be automated, but there's no way
to do this other than with VBA or manually.
 
Top