WHY HAVE FORMULAS STOPPED WORKING IN 2020 EXCEL FOR BUSINESS

%3CLINGO-SUB%20id%3D%22lingo-sub-1576520%22%20slang%3D%22en-US%22%3EWHY%20HAVE%20FORMULAS%20STOPPED%20WORKING%20IN%202020%20EXCEL%20FOR%20BUSINESS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576520%22%20slang%3D%22en-US%22%3E%3CP%3EUPPER%3C%2FP%3E%3CTABLE%20width%3D%22121%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3DUPPER(B2)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EThe%20formulas%20displays%20but%20will%20not%20calculate.%26nbsp%3B%20I%20think%20I%20check%20all%20the%20places%20that%20would%20cause%20this%20and%20do%20not%20find%20a%20selection%20that%20would%20just%20show%20the%20formula.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20did%20get%20this%20to%20work%20after%20a%20few%20rows%20it%20entered%20random%20text%20but%20not%20what%20it%20should%20have.%3C%2FP%3E%3CP%3ELinda%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1576520%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576555%22%20slang%3D%22en-US%22%3ERe%3A%20WHY%20HAVE%20FORMULAS%20STOPPED%20WORKING%20IN%202020%20EXCEL%20FOR%20BUSINESS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576555%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660002%22%20target%3D%22_blank%22%3E%40LINDA1259%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20I%20understood%20the%20problem%3C%2FP%3E%3CP%3Ethe%20function%20still%20works%20in%20Excel%20365.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emaybe%20autocalculate%20is%20not%20active%3F%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20you%20upload%20a%20sample%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576557%22%20slang%3D%22en-US%22%3ERe%3A%20WHY%20HAVE%20FORMULAS%20STOPPED%20WORKING%20IN%202020%20EXCEL%20FOR%20BUSINESS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576557%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660002%22%20target%3D%22_blank%22%3E%40LINDA1259%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EMake%20sure%20that%20the%20cells%20with%20formulas%20are%20NOT%20formatted%20as%20Text%2C%20but%20for%20example%20as%20General.%3C%2FLI%3E%0A%3CLI%3EMake%20sure%20that%20'Show%20Formulas'%20has%20NOT%20been%20selected%20in%20the%20'Formula%20Auditing'%20group%20of%20the%20Formulas%20tab%20of%20the%20ribbon.%3C%2FLI%3E%0A%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

UPPER

=UPPER(B2)
 

The formulas displays but will not calculate.  I think I check all the places that would cause this and do not find a selection that would just show the formula.  

 

When I did get this to work after a few rows it entered random text but not what it should have.

Linda

2 Replies

@LINDA1259 

 

I am not sure I understood the problem

the function still works in Excel 365. 

 

maybe autocalculate is not active? 

can you upload a sample file?

@LINDA1259 

  1. Make sure that the cells with formulas are NOT formatted as Text, but for example as General.
  2. Make sure that 'Show Formulas' has NOT been selected in the 'Formula Auditing' group of the Formulas tab of the ribbon.