How do I fix my formulas in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Make sure Automatic Calculations are turned on.

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

HTH,
Elkar
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top