How do I fix my formulas in Excel?

[Jake]

I recently moved to another office in my building and installed a wireless
mouse/keyboard and a different printer. Now, none of my formulas in excel
are working. I can change the values in the equation and the data in the
answer cell stays the same as it was before. I believe any new workbooks are
ok and carry the formulas, just not any old files I had.

[Elkar]

Make sure Automatic Calculations are turned on.

TOOLS --> OPTIONS --> CALCULATION Tab --> Check "Automatic"

HTH,
Elkar


"Jake" wrote:

> I recently moved to another office in my building and installed a wireless
> mouse/keyboard and a different printer. Now, none of my formulas in excel
> are working. I can change the values in the equation and the data in the
> answer cell stays the same as it was before. I believe any new workbooks are
> ok and carry the formulas, just not any old files I had.

[CLR]

Check the Tools > Options > CalculationsTab, to see that "Calculation" is set
to Automatic..........otherwise, your old workbooks may have contained
extensive linking to other files whose path is now changed in your new
location.

Vaya con Dios,
Chuck, CABGx3



"Jake" wrote:

> I recently moved to another office in my building and installed a wireless
> mouse/keyboard and a different printer. Now, none of my formulas in excel
> are working. I can change the values in the equation and the data in the
> answer cell stays the same as it was before. I believe any new workbooks are
> ok and carry the formulas, just not any old files I had.