Hi Everyone.. I guess I have been using Excel for longer than I care to remember. I have a workbook with several worksheets. Data inputted into 1 of the worksheets is calculated and displayed in the other sheets and produces various reports.

No problems until yesterday. Then this... I type in the formula, using a previously unused cell, and no problems the data in the sheet I am refering to in the formula appears in this other worksheet.

HOWEVER !! and this is the bit I don't get, if I have to edit the formula, then I can find no way to get the data to display, it constantly shows just the forumula.

The worksheet I am copying from is named Day 1 and an example cell is AT4.

So in my other worksheet I enter the formula 'Day 1'!AT4 and if it the first time then it's OK.

By the way..... why do so many instruction show the worksheet being refered to as simply Day1 without the ' ' around it. I have many different worksheets and never been able to get them to accept the sheet name without the ' '

Thanks for your time...... I hope someone has an answer..

Excel 2003 on XP Pro. 36 worksheets in one workbook. There is one for each day of the week and 5 for various analysis reports.


Peter
Winnipeg
Canada