Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas are right, does not total at the end.
Hi,
So I have a worksheet that I've worked with for months with no problem. All of the sudden it is now neccesary to highlight the formula cell and press enter for it to work the formula and come up with the right #. I've never seen this before...hopfully somone out there has and knows how to fix it. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas are right, does not total at the end.
Make sure calculation is set to automatic.
ToolsOptionsCalculation tabAutomatic -- Biff Microsoft Excel MVP "Limegirl" wrote in message ... Hi, So I have a worksheet that I've worked with for months with no problem. All of the sudden it is now neccesary to highlight the formula cell and press enter for it to work the formula and come up with the right #. I've never seen this before...hopfully somone out there has and knows how to fix it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy formulas across a 1-31 day file and month end total | Excel Discussion (Misc queries) | |||
pivot table formulas - running total | Excel Discussion (Misc queries) | |||
Keeping formulas on running total and sorts | Excel Worksheet Functions | |||
Counting or Total Formulas -- Further Explanation | Excel Worksheet Functions | |||
Pivot Table Grand Total wrong when using Formulas | Excel Discussion (Misc queries) |