Forum Discussion

Daniel Colardelle's avatar
Daniel Colardelle
Copper Contributor
Aug 30, 2016

Excel 2016 french L1C1 reference style issue

Excel fr, Windows 10 fr (1511) When used as a string, you could write : =INDIRECT("L1C1";FAUX) (returns A1 value). Now, since a few days, it returns #REF! You have to write : =INDIRECT("R1C1";FA...
Formulas & Functions
Need Help
Deleted's avatar
Deleted
Aug 31, 2016

Hi Daniel,

 

I tried following cases in an Excel 2016 Build 16.0.7167.2040 Insider Version:

 

Excel in English =INDIRECT("R1C1";FALSE) results in value from A1
Excel in German  =INDIREKT("Z1S1";FALSCH) results in the error #BEZUG! meaning #REF!
Excel in German  =INDIREKT("R1C1";FALSCH) results in the error #BEZUG! meaning #REF!
Excel in French  =INDIRECT("L1C1";FAUX) results in the error #REF!
Excel in French  =INDIRECT("R1C1";FAUX) results in value from A1

So, I see the same problem as you and I think there is something wrong.

 

Best Regards,
Mourad

  • Daniel Colardelle's avatar
    Daniel Colardelle
    Copper Contributor
    Aug 31, 2016

    Hi Mourad,

    Thanks for answering. Hope it will be quickly fixed.

    Daniel

    • Deleted's avatar
      Deleted
      Aug 31, 2016

      Hi Daniel,

       

      I have posted the problem to the http://answers.microsoft.com/en-us/office/forum/office_insider-excel/indirect-function-is-broken-at-least-for-excel-in/1fcbcf20-a103-4172-abf1-2c0dfe848e60 with back reference to this thread. Yes, let's hope, it will be fixed :-)

       

      Best Regards,

      Mourad

      • Daniel Colardelle's avatar
        Daniel Colardelle
        Copper Contributor
        Aug 31, 2016

        Thanks a lot Mourad.

Resources