Concat function not viewable by specific people

%3CLINGO-SUB%20id%3D%22lingo-sub-2932269%22%20slang%3D%22en-US%22%3EConcat%20function%20not%20viewable%20by%20specific%20people%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2932269%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20figure%20something%20out.%26nbsp%3B%20Doing%20some%20spreadsheets%20for%20a%20client%20and%20I%20used%20the%20concat%20function%20in%20some%20of%20the%20columns%2C%20the%20client%20is%20unable%20to%20see%20anything%20in%20those%20columns.%26nbsp%3B%20It%20is%20just%20completely%20blank%20for%20them%2C%20it%20isn't%20even%20showing%20the%20function%20or%20anything.%26nbsp%3B%20Just%20nothing%20in%20there%20like%20I%20didn't%20fill%20it%20out.%26nbsp%3B%20Others%20inside%20my%20org%20are%20able%20to%20open%20it%20and%20see%20the%20results.%26nbsp%3B%20The%20vendor%20the%20spreadsheet%20is%20for%20can%20open%20it%20and%20see%20the%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20the%20client%20cannot%20see%20the%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHe%20even%20saved%20a%20copy%20directly%20from%20the%20version%20I%20sent%20and%20sent%20it%20back%20to%20me....%20and%20the%20columns%20are%20all%20filled%20out%20for%20me%2C%20but%20on%20his%20excel%20(latest%20version%20from%20O365%20same%20as%20me)%20he%20is%20unable%20to%20see%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20why%20this%20is%20and%20or%20how%20to%20fix%20it%20as%20he%20wants%20to%20review%20before%20the%20vendor%20uploads%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDerek%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2932269%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-2933918%22%20slang%3D%22en-US%22%3ERe%3A%20Concat%20function%20not%20viewable%20by%20specific%20people%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2933918%22%20slang%3D%22en-US%22%3EYou%20are%20probably%20on%20different%20Excel%20versions.%3CBR%20%2F%3ECONCAT()%20is%20available%20for%3A%3CBR%20%2F%3EExcel%20for%20Microsoft%20365%3CBR%20%2F%3EExcel%20for%20Microsoft%20365%20for%20Mac%3CBR%20%2F%3EExcel%20for%20the%20web%3CBR%20%2F%3EExcel%202021%3CBR%20%2F%3EExcel%202021%20for%20Mac%3CBR%20%2F%3EExcel%202019%3CBR%20%2F%3EExcel%202019%20for%20Mac%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi all,

 

Trying to figure something out.  Doing some spreadsheets for a client and I used the concat function in some of the columns, the client is unable to see anything in those columns.  It is just completely blank for them, it isn't even showing the function or anything.  Just nothing in there like I didn't fill it out.  Others inside my org are able to open it and see the results.  The vendor the spreadsheet is for can open it and see the results.

 

But the client cannot see the results.

 

He even saved a copy directly from the version I sent and sent it back to me.... and the columns are all filled out for me, but on his excel (latest version from O365 same as me) he is unable to see them.

 

Any ideas on why this is and or how to fix it as he wants to review before the vendor uploads the data.

 

Thanks in advance,

 

Derek

1 Reply
You are probably on different Excel versions.
CONCAT() is available for:
Excel for Microsoft 365
Excel for Microsoft 365 for Mac
Excel for the web
Excel 2021
Excel 2021 for Mac
Excel 2019
Excel 2019 for Mac