I'm having a problem with automatic calculation. It is set correctly in
OPTIONS and I haven't opened a previous spreadsheet that was set to MANUAL
(as one of the posts suggested).

I have a spreadsheet that contains only formulas. The data is pulled into
this spreadsheet from another workbook by way of the formula, for example:

The formula spreadsheet is named QUM and the data spreadsheet is named QASC
P1. The cells in the QUM spreadsheet contain the formula below:

=IF('QASC P1!B5="",0,1) testing to see what is in cell B5 of the QASC P1
workbook.

The only way that I see the data is to edit the cell in QASC P1 the hit
RETURN. F9 doesn't work either. Help! Thank you.