It sounds like that user on the other pc is formatting the cell (all the
cells???) as Text.

It could be a choice by the user.
It could be that the user copied another worksheet that was set up that way.
It could be that they created a book.xlt template workbook that was set up for
text.

Difficult to know without asking that other user.

I think I'd look at the book.xlt (in XLStart) first. Verify that the cells are
all formatted as general.

Jeffry61 wrote:

Dave, your fix works, but it must be applied to every new spreadsheet.
Formulas is not checked, but the new spreadsheets do not have general
formatting to begin with. If new spreadsheet is changed to general
formatting before use, replacing = with = can be skipped.

Don't know why the replacing = with = corrects bad sheets after changing
their format, but more importantly don't know why I have to change the format
for each new sheet.
Thanks.

"Dave Peterson" wrote:

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


--

Dave Peterson