Problems with # NAME in Excel 2016.

%3CLINGO-SUB%20id%3D%22lingo-sub-2854783%22%20slang%3D%22en-US%22%3EProblems%20with%20%23%20NAME%20in%20Excel%202016.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2854783%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%2050%20columns%20and%205%2C000%20lines.%26nbsp%3B%20It%20worked%20well%20before.%20A%20few%20days%20ago%2C%20without%20changing%20anything%2C%20it%20started%20to%20show%20in%20almost%20all%20cells%20%23%20NAME.%26nbsp%3B%20I%20cannot%20find%20what%C2%B4s%20going%20on.%20The%20surprising%20thing%20is%20that%2C%20without%20changing%20any%20formula%20or%20moving%20anything%20to%20another%20cell%2C%20if%20I%20touch%20the%20parenthesis%20in%20one%20of%20the%20cells%20that%20shows%20%23%20NAME%2C%26nbsp%3B%20the%20correct%20number%20appears%2C%20eliminating%20the%20message%20%23%20NAME.%26nbsp%3B%20The%20cell%20stores%20the%20number%2C%20but%20it%20cannot%20show%20it.%26nbsp%3B%20%26nbsp%3B%20Apparently%2C%20it%20dos%20not%20recognize%20text%20in%20conditional%20clauses%20like%26nbsp%3B%20IF%20(a20%3D%20%22%22%2C%20b20%2C0)%20and%20similar%20ones.%26nbsp%3B%20This%20never%20happended%20in%20the%20past.%26nbsp%3B%20I%20am%20attaching%20part%20of%20the%20file.%26nbsp%3B%20If%20someone%20touches%20the%20parentheis%26nbsp%3B%20or%20bracket%20in%20cell%20j307%20for%20instance%2C%20the%20cell%20will%20show%20the%20content......%20But%20what%C2%B4s%20hapenning%3F%26nbsp%3B%20%26nbsp%3B.%20I%20have%20to%20adjust%20all%20formulas%20manually%20to%20see%20the%20numbers.%20%26nbsp%3B%20%26nbsp%3BThanks%20to%20everyone%20who%20can%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2854783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2858075%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20%23%20NAME%20in%20Excel%202016.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2858075%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1187550%22%20target%3D%22_blank%22%3E%40Marcvar8%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%20Community%20Discussion%20space%3C%2FA%3E%3CSPAN%3E%2C%20%3C%2FSPAN%3Ewhich%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2859370%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20%23%20NAME%20in%20Excel%202016.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2859370%22%20slang%3D%22en-US%22%3EThank%20you%20Eric.%20I%20apologize%20for%20the%20mistake.%20I%20tried%20to%20place%20correctly.....%20I%20will%20go%20to%20the%20Excel%20space.%20Good%20bye%20!!%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I have a spreadsheet with 50 columns and 5,000 lines.  It worked well before. A few days ago, without changing anything, it started to show in almost all cells # NAME.  I cannot find what´s going on. The surprising thing is that, without changing any formula or moving anything to another cell, if I touch the parenthesis in one of the cells that shows # NAME,  the correct number appears, eliminating the message # NAME.  The cell stores the number, but it cannot show it.    Apparently, it dos not recognize text in conditional clauses like  IF (a20= "", b20,0) and similar ones.  This never happended in the past.  I am attaching part of the file.  If someone touches the parentheis  or bracket in cell j307 for instance, the cell will show the content...... But what´s hapenning?   . I have to adjust all formulas manually to see the numbers.    Thanks to everyone who can help me.

2 Replies

@Marcvar8 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

Thank you Eric. I apologize for the mistake. I tried to place correctly..... I will go to the Excel space. Good bye !!