ExcelBanter - how 2 spreadsheets in diff locations with auto update

hi,
you didn't say if there was a change that the other file might be open by
another user. if so you will have problems what ever you do.
I have a situation where i have to save a file it 2 different
locations.(duel backup)
I wrote a macro that saves the file in the three different loactions. you
can do it on record and put the macro in a this workbook module in the before
save event or before close event. in the before save event, it will
automaticly save to the second loaction when ever you save the file to your c
drive.
Otherwise you would have to use drive formulas in the second file and that
is a hassel i assure you becasue each cell needs it own formula. I only
recomend drive formulas when you are creating a summary and not the entire
workbook.
here is an example of a dirve formula that counts.
=COUNTA('S:\PUBLIC\Ae-pc\WOM\FY03\[WOMJan.xls]MPX'!$A$4:$A$500)
one that just draws data.
=('S:\PUBLIC\Ae-pc\WOM\FY03\[WOMJan.xls]MPX'!$A$4)
one that sums
=SUM('S:\PUBLIC\Ae-pc\MOM\FY03\[WOMJan.xls]MPX'!$Z$4:$Z$500)

good luck
FSt1

"confused in uk" wrote:

Does anyone know how to save the same Excel spreadsheets in different
locations but you only need to update one and the other will auto update?