Hi All
I have created a spreadsheet in Excel 2003, that has a number of countif formulas linked to another worksheet in the same workbook and up until today they have been working perfectly when the data on the workbook changes.
This morning I pasted a new months worth of data into the workbook and the formulas on the other pages will not update. If I go into the formula and hit enter the formula works. I have checked the Options and I do have the Auto Calc on. When I press F9 nothing changes. It is only when I go into the formula and hit enter that it changes.
What on earth is going on here????
I have created a spreadsheet in Excel 2003, that has a number of countif formulas linked to another worksheet in the same workbook and up until today they have been working perfectly when the data on the workbook changes.
This morning I pasted a new months worth of data into the workbook and the formulas on the other pages will not update. If I go into the formula and hit enter the formula works. I have checked the Options and I do have the Auto Calc on. When I press F9 nothing changes. It is only when I go into the formula and hit enter that it changes.
What on earth is going on here????