How to update a linked spreadsheet without opening it?

K

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
 
H

HKBigB

I will say - NO.

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