How to update a linked spreadsheet without opening it?

[kpax]

Hello experts,

I have two Excel 2000 spreadsheets, S1 and S2. S1 is linked to S2.

When values in S2 are changed and saved, I need S1 to update its value
itself WITHOUT ME MANUALLY OPENING S1 AND UPDATING IT.

Can I update S1 without opening it and how?

Thanks vey much for your help

 

[Frank Kabel]

Hi
AFAIK no chance to do this

 

[HKBigB]

I will say - NO.

But whenever you open the S1 file, it will ask you to update all linke
information

 

[kpax]

Thanks for your feedbac