View Single Post
 
Old 09-05-2015, 04:41 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default Excel Structured Referencing: non-English reference?

Code:
English version
=Table1[[#Totals],[Column1]]
When the file with the formula above is opened and edited on a non-English Windows OS, the formula will be converted into that non-English language in the part of

Code:
[#Totals]
Is there a way to avoid that and keep the English version? Because when the file with the non-English ones is edited on an English Windows OS, the formula returns error.

Any help is appreciated!
Reply With Quote