Excel 2003 - Formulas on one worksheet (pMon) referring to another worksheet
(pCSRs) all-of-a-sudden stopped updating when the information on the second
worksheet changed. These are simple formulas without calculation, such as
=pCSRs!F92. Calculation is set to automatic, and even when I press F9 they
don't update.

This has worked for a long time, but I have recently been making changes to
other worksheets by importing data from another similar workbook. However
none of the problem formulas involved have a reference to the other workbook
(nothing like ='[Workbook2]pCSRs'!F92). Any ideas?