Forum Discussion
ms office formula gives 0
jenn12 wrote: ``all data are set to numbers. [....] never had issues with that format``
As I said: the format of the cell does not matter; and looks can be deceiving.
Did you try formulas of the form =ISNUMBER(A1) for all of the "numbers"?
One thought: did you try (re)entering one of the "numbers" manually?
(Be sure the cell format is General or another numeric format first.)
-----
jenn12 wrote: ``circular reference is not highlighted``
Not sure what you mean by that. The circ ref notification might not appear in the lower left of the status bar (bottom of display). But you might still have circ refs somewhere -- perhaps not the active worksheet.
Unfortunately, you have go to each worksheet one-by-one and click Formulas > Error Checking > Circular References (if not grayed out).
-----
jenn12 wrote: ``tried both manual and automatic``
Another very unlikely possibility: EnableCalculation for the worksheet(s) is disable.
If that were the case, toggling Automatic Calculation on and pressing any of the f9 shortcuts do not work.
That state is controlled with VBA code. But you might have a defective add-in that is leaving that state set.
If you know how to use VBA, you can go into the Immediate Window and type
? ActiveSheet.EnableCalculation
to see the current state.
-----
jenn12 wrote: ``I am honestly going bananas``
Understandable.
If all else fails, the best and quickest way to get help is to attach an example Excel file (redacted) that demonstrates the problem.
I know: there are reasons why you might balk; and there are reasons why you are not allowed to.
But if you simply copy and paste-value the "numbers", enter the SUM formula, and strip away everything else, I don't see any risk.
2. i tried both manual and automatic - nothing works.
3. circular reference is not highlighted so I can't use that as an option.
4. i updated all my drivers and installed all new updates, cleaned my computer still the same..
Excel version: i believe i have the updated version as i have a monthly subscription and have been using 365 since 2016. This is the first time, i got issues.
I am honestly going bananas trying to crack my few brain cells out to fix this...maybe i let my computer sleep overnight and try again tomorrow
jenn12 wrote: ``all data are set to numbers. [....] never had issues with that format``
As I said: the format of the cell does not matter; and looks can be deceiving.
Did you try formulas of the form =ISNUMBER(A1) for all of the "numbers"?
One thought: did you try (re)entering one of the "numbers" manually?
(Be sure the cell format is General or another numeric format first.)
-----
jenn12 wrote: ``circular reference is not highlighted``
Not sure what you mean by that. The circ ref notification might not appear in the lower left of the status bar (bottom of display). But you might still have circ refs somewhere -- perhaps not the active worksheet.
Unfortunately, you have go to each worksheet one-by-one and click Formulas > Error Checking > Circular References (if not grayed out).
-----
jenn12 wrote: ``tried both manual and automatic``
Another very unlikely possibility: EnableCalculation for the worksheet(s) is disable.
If that were the case, toggling Automatic Calculation on and pressing any of the f9 shortcuts do not work.
That state is controlled with VBA code. But you might have a defective add-in that is leaving that state set.
If you know how to use VBA, you can go into the Immediate Window and type
? ActiveSheet.EnableCalculation
to see the current state.
-----
jenn12 wrote: ``I am honestly going bananas``
Understandable.
If all else fails, the best and quickest way to get help is to attach an example Excel file (redacted) that demonstrates the problem.
I know: there are reasons why you might balk; and there are reasons why you are not allowed to.
But if you simply copy and paste-value the "numbers", enter the SUM formula, and strip away everything else, I don't see any risk.
- Hi there..
I just around and did what you wrote..After a series of attempts, it worked again. Thanks for the help