1.  Open all workbooks needed.
2.  In the cell where you want the total, type an equal sign (=).
3.  Then switch to the first workbook you want to work with (Window
menu) and click on the cell you want.  It will be in the formula bar
with the workbook name, sheet name, and the cell.
4.  Type a plus sign (+).
5.  Repeat steps 3 and 4 until you have gathered all the cells you
want.  Do not end with a plus sign.
6.  Press Enter.  You will end up in the original workbook with the
total from the cells you selected in the other workbooks.  The files in
the formula are linked to the original workbook.  When you open the
original workbook you will be given a choice of whether you want to
update the totals.  The linked files do not have to be open.

There are several other ways to consolidate information in Excel.



-----Original Message-----
From:   Darlene Bost [SMTP:[log in to unmask]]
Sent:   Friday, July 24, 1998 10:08 AM
To:     [log in to unmask]
Subject:        [PCSOFT] Excel - Working with several workbooks

Hi,
I have an individual workbook set up for each of our locations (5) to
be
used as a timesheet.  Every time sheet has the same categories to log
time
into.  We are trying to see how much time is spent on "proactive work"
as
opposed to "reactive work", we are not trying to account for every
minute a
person is at work though.  Every employee for each location has their
own
sheet.  At the end of the workbook is a sheet title "everyone" which
tallies time for the location for the month.  I now need to develop a
workbook that will automatically tally the monthly numbers from each
location into one workbook.  I opened all the workbooks, selected the
cells
from each one for totals and it comes up with #VALUE.  As I'm not an
Excel
guru, can someone tell me what I'm doing wrong?

Regards,

Darlene