Excel question

[max_rayhm]

Hi, I need your help. I have 2 spreadsheets, one with the data and another
with references to the data. If a make a change in the

data, in the spreadsheets with the references no changes its values. I don't
want to use the manual way, that is to say, press the

button "update values" in option Edit, References in window "Modify
References".

Please help me. I'm using MS Office Excel 2003 SP2.

Thanks

 

[Don Guillett]

A better explanation?

 

[max_rayhm]

Thanks for your attention

I have 2 spreadsheets. One with data (SS1) and another with references (SS2).
If I change the value of one cell in SS1, in SS2 show the old value and not
the new one.
I need an automatic update, without use the "manual" option Edit > Links (or
reference) > Update Values.

Thanks again

 

[Don Guillett]

Still not clear

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.