Thanks for replying,

There are 12 folder, one for each month, with a subfolder for the month
end totals.
A thirteenth folder for the year.

A typical example of the change would be:

=SUM('[01.xls]MOVE & HANDLE'!$D$3,'[02.xls]MOVE &
HANDLE'!$D$3,'[03.xls]MOVE & HANDLE'!$D$3,'[04.xls]MOVE &
HANDLE'!$D$3,'[05.xls]MOVE & HANDLE'!$D$3,'[06.xls]MOVE &
HANDLE'!$D$3,'[07.xls]MOVE & HANDLE'!$D$3,'[08.xls]MOVE &
HANDLE'!$D$3,'[09.xls]MOVE & HANDLE'!$D$3,'[10.xls]MOVE &
HANDLE'!$D$3,'[11.xls]MOVE & HANDLE'!$D$3,'[12.xls]MOVE &
HANDLE'!$D$3,'[13.xls]MOVE & HANDLE'!$D$3,'[14.xls]MOVE &
HANDLE'!$D$3,'[15.xls]MOVE & HANDLE'!$D$3,'[16.xls]MOVE &
HANDLE'!$D$3)+SUM('[17.xls]MOVE & HANDLE'!$D$3,'[18.xls]MOVE &
HANDLE'!$D$3,'[19.xls]MOVE & HANDLE'!$D$3,'[20.xls]MOVE &
HANDLE'!$D$3,'[21.xls]MOVE & HANDLE'!$D$3,'[22.xls]MOVE &
HANDLE'!$D$3,'[23.xls]MOVE & HANDLE'!$D$3,'[24.xls]MOVE &
HANDLE'!$D$3,'[25.xls]MOVE & HANDLE'!$D$3,'[26.xls]MOVE &
HANDLE'!$D$3,'[27.xls]MOVE & HANDLE'!$D$3,'[28.xls]MOVE &
HANDLE'!$D$3,'[29.xls]MOVE & HANDLE'!$D$3,'[30.xls]MOVE &
HANDLE'!$D$3,'[31.xls]MOVE & HANDLE'!$D$3)


The change would be the final cell..i.e. $D$3 would become $E$3,

And as ther is multiple calculations per sheet, this ruins the whole
lot when transferred between computers.

I hope you can help....Thanks again

Stephen McArthur


--
Stephen McArthu
------------------------------------------------------------------------
Stephen McArthu's Profile: http://www.excelforum.com/member.php...o&userid=24054
View this thread: http://www.excelforum.com/showthread...hreadid=376688