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
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