question

ANDRESASJ-7190 avatar image
0 Votes"
ANDRESASJ-7190 asked emilyhua-msft commented

Excel Formula not changing

When ever I enter a new formula onto a cell it does not change or show me possible formulas to use as I type. To fix this I need to change it from "fx".

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft commented

@ANDRESASJ-7190
According to your description, I have a few questions:

  • Does all workbooks have this problem regardless of the cell formats (Such as Number, General, Date, and etc.)?
    Please ensure the cells are not set as text format.

  • When entering the equal sign and formula in the formula bar, does any error message pop up?
    Please take a screenshot of the cell that you enter formula in.

  • In addition, the input method should use English half-width symbols.

  • It is also recommended to press F9 or Fn+F9 to refresh.
    If this works, please go to File > Options > Formulas, tick the box of "Auomatic" under Caculation options section.

  • If the steps above do not work, please run Excel in safe mode, hold down the Ctrl key, double-click the Excel icon to open Excel, and select “Yes” enable safe mode of Excel. Then create a blank workbook to test whether the function can work normally.
    Safe mode can help us troubleshoot third-party add-ons, as well as startup items.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I tried all the options you have mentioned none have worked but starting excel in Safe Mode. Safe Mode is allowing my function to work and giving me the drop-down option as I type after "=".

I've also already tried reinstalling office.

Thank you

0 Votes 0 ·

@ANDRESASJ-7190
Thanks for your sharing.
If safe mode allow you enter Excel functions, this issue may caused via add-ins.
So, if you encounter this issue again after reinstalling Office later, please go to File > Options > Add-ins > Manage COM add-ins > Go.
Then clear the check boxes for any enabled COM add-ins, select OK.
If disabling the COM add-ins alleviates the issue, try enabling them one at a time to test for the problem add-in.

0 Votes 0 ·

Sorry for the late response, but I only had Acrobat PDFMaker Office COM Addin enabled, and after disabling it the problem persisted. What else should I do?

Also after changing the addins safe mode is no longer working and I'm experiencing the same issues on it as well.

0 Votes 0 ·
Show more comments