My apologies if this is in the wrong forum, I wasn't sure which forum to put it in. I'm a network admin and I am trying to help one of my users. He works on very large spreadsheets with multiple worksheets. On one worksheet, he references another worksheet. But when he changes the number in the referenced worksheet, the number is not updated in the other worksheet. alt+ctrl+f9 does update it, but I want a more permanent fix where he woulden't need to remember to do this for every file.

Simple example is he has worksheets A and B. In A, a cell references a cell in B that has '2' in the cell. '2' will also how up on A. But when he changes the '2' to a '3' in B, that same change is not shown in worksheet A.

He has Excel 2003 SP3.

Thanks