SOLVED

Windows 10 Excel for PC formula error help

%3CLINGO-SUB%20id%3D%22lingo-sub-2423113%22%20slang%3D%22en-US%22%3EWindows%2010%20Excel%20for%20PC%20formula%20error%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2423113%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20not%20allow%20me%20to%20exit%20after%20viewing%20formula%20error%20from%20the%20help%20mode.%3C%2FP%3E%3CP%3EI%20fear%20I've%20lost%20the%20excel%20document%20and%20am%20unable%20to%20retrieve.%3C%2FP%3E%3CP%3EAfter%20spending%20all%20afternoon%20analyzing%20I'm%20asking%20for%20help!%3C%2FP%3E%3CP%3EPlease%20and%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2423113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2423168%22%20slang%3D%22en-US%22%3ERe%3A%20Windows%2010%20Excel%20for%20PC%20formula%20error%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2423168%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1073087%22%20target%3D%22_blank%22%3E%40BabaWawa56%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EActivate%20the%20Formulas%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EYou'll%20see%20that%20the%20Show%20Formulas%20button%20in%20the%20Formula%20Auditing%20group%20is%20highlighted.%3C%2FP%3E%0A%3CP%3EClick%20this%20button%20to%20turn%20it%20off.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0485.png%22%20style%3D%22width%3A%20326px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286972iFA3EBC2591825CAF%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0485.png%22%20alt%3D%22S0485.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Does not allow me to exit after viewing formula error from the help mode.

I fear I've lost the excel document and am unable to retrieve.

After spending all afternoon analyzing I'm asking for help!

Please and Thank you.

2 Replies
best response confirmed by BabaWawa56 (New Contributor)
Solution

@BabaWawa56 

Activate the Formulas tab of the ribbon.

You'll see that the Show Formulas button in the Formula Auditing group is highlighted.

Click this button to turn it off.

S0485.png

Hans, you are a lifesaver! Thanks so much. I've wasted hours on this! Enjoy your day!