saving the same file in different places at a time

S

sitaram

hi,
i have an excel file in one system
when i update this file, is it possible some range of
cells in this file to be saved in the different system
also

how do i give a link to the other file?

appreciate, if anyone could help
 
S

Steve

Sounds like you want to paste a link so that the cell will
update every time the other cell gets new info...

To do this, say you want to link cell A1 to cell
A7...click on cell A7 and click copy...Go to cell A1 and
click paste...Then (if you have Excel 2003), click on
Edit/Paste Special/Paste Link and you now have youe
link...The "Paste Link" Button is in the lower left-hand
corner of the Paste Special Box...

GL...

Steve
 
S

sitaram

thanks for reply..
my question is ..
there are file1 & file2 in system1 syste2
file2 in system2 is the copy of certain range of cells of
file1 in system2
is it possible getting the affect in file2, when the
file1 is updated in system1

thanks & regards
sitaram
 
Top