It could be that the first workbook opened had calculation set to manual.

--
Don Guillett
SalesAid Software

"F. Lawrence Kulchar" wrote in
message ...
I HAVE FOUND THE ANSWER:

TOOLS...OPTIONS...check automatic calculation...

it was unchecked...manual was checked,,,I do NOT know how it happened...I
thought I was going NUTS

"F. Lawrence Kulchar" wrote:

EVEN when i type in cell

B1..............=A1,

IT DOES NOT WORK!!!

Somewhere I have some setting in EXCEL misplaced...none of the
spreadsheet
formulas work.

PLEASE HELP

FLKulchar