Try formatting all the cells with formulas as General (all the cells on the
worksheet???).

Select your range to fix (ctrl-a (twice in xl2003) will select all the cells)
edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

Don's guess was the equivalent of
Tools|Options|View tab|unchecking formulas
(You may want to double check that before you start)

Jeffry61 wrote:

New info: according to the Formula watch window, the cells with formulas are
not seen as formulas, but as data. Typing = in a cell starts the formula
assistant, but when done it is seen as data instead of a formula.

"Jeffry61" wrote:

Any Excel sheet created by another PC is ok. Any sheet created by this PC
will not calculate regardless of the PC used. The formulas display, but not
the results. Comparing every option of Tools Protection, Tools Options,
Format cells or style between 2 pcs when each is loaded with their own
created spreadsheets, show no difference. No errors are detected. It does
not matter what kind of formula or how simple.

--

Dave Peterson