Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I fix my formulas in Excel?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I fix my formulas in Excel?
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I fix my formulas in Excel?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |