How do I fix my formulas in Excel?

J

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.
 
E

Elkar

Make sure Automatic Calculations are turned on.

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

HTH,
Elkar
 
C

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
 
Top