Forum Discussion

Derek1540's avatar
Derek1540
Copper Contributor
Nov 05, 2021

Concat function not viewable by specific people

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

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    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
    • wally_david's avatar
      wally_david
      Copper Contributor

      Detlef_Lewin 

      This was a life saver! Some people in my company are on Excel 2016 and concat was causing the problem. 

Resources