Hi I’m looking for some help on Excel 2007 which has been doing my head in for a while now.

I’m using excel to add up the results from a number of different time sheets at work, Each person has a workbook with 5 worksheets Week 1 to 4 and then total sheet which adds up the results (we have different codes for different activities which are added up with a countif formula). I now need to add up all the totals for everyone onto one sheet.

I know only a little bit about excel so what I’ve done is setup a master work book and pasted in a copy of each persons total for there sheet, then the final sheet adds up all the information which seems to work fine until I go out and come back into the sheet. I then get a message saying this workbook contains links to other data sources. If I click don’t update then everything seems to be ok however I guess this won't bring in the updated figures if anyone has changed their time sheet? If I click update the then excels throws a bit of a wobbler and fills the spreadsheet with #VALUE! error, this is really driving me mad as the error doesn’t appear on everyone’s time sheet, and if I go in and open each persons original time sheet then this then gets rid of the error on the master time sheet.

Sorry it not the greatest explanation but I wondered if anyone could offer any advice on how I can stop excel from showing this error, any help would be great. Thanks Dave