Forum Discussion

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

Copper Contributor

Sep 03, 2016

Case matters ! I didn't notice this before : Excel in French =INDIRECT("L1C1";FAUX) results in the error #REF! Excel in French =INDIRECT("l1C1";FAUX) results in value from A1 Best regards. Daniel

Anonymous

Sep 04, 2016

Hi Daniel,

the problem is solved on my installs with the latest update of Excel 2016 to Build 16.0.7341.2021 (Office Insider Slow) and Z1S1 and L1C1 are working as expected again. Thanks, MS :-)

Best Regards,

Mourad

Daniel Colardelle
Copper Contributor
Sep 04, 2016
Hi Mourad,

Thanks. I pass this to my user. I also invited him to subscribe to the Ofice Insider Program.

Best regards
Daniel