Forum Discussion

NakitaO_'s avatar
NakitaO_
Copper Contributor
Oct 29, 2020

Excel on Windows PC to Macbook

Hi there,

 

Wondering if anyone would know or have any advice for me.

 

I am working with a nutritionist who has formulated an excel spreadsheet counting calories for me. She is working on a Windows PC (Laptop) and I am on a MacBook. When she sends the spreadsheet to me, when I open it, the formulas change on my side and are different from what she had inputted... How do I resolve this or how can she save it so it doesn't change when I open it? Or perhaps something I should do before opening it? TIA!!

3 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    NakitaO_ 

    If your nutritionist is on a more modern version it could be that she uses functions that are not supported by yours. This will show as errors on your side.

    If you are using different language versions, the formulae will look different for both, but they will still work as intended. 

     

    If this does not explain your situation, please give some explanation of how formulae change. What has your nutritionist typed and what do see on your end.

    • NakitaO_'s avatar
      NakitaO_
      Copper Contributor

      Riny_van_Eekelen 

      Thanks so much for your reply.

      Below is how the formula it is supposed to be and how it is on the Windows OS as well as what it looks like when I open it... does this make any sense to you? Do you think it's a more modern version? Because it doesn't work when I open it on my MacBook...

       

      MacBook: =C9+_xlfn.XLOOKUP(Female!C12;'drop down'!B2:B7;'drop down'!C2:C7)

      {do you know what that _xlfn. Is?}

       

      Windows (how it should be): =C9+XLOOKUP(Female!C12,'drop down'!B2:B7,'drop down'!C2:C7)

Resources