Excel Structured Referencing: non-English reference?

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Structured Referencing: non-English reference?

FAQ

Thread Tools

Display Modes

09-05-2015, 04:41 AM

tinfanide

Windows 7 64bit Excel Structured Referencing: non-English reference?

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

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!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating macros for a well structured analysis system	chillerlegend	Excel Programming	1	06-21-2015 05:28 AM
excel absolute reference	dschlachter	Excel	6	06-16-2015 03:02 PM
Finding Non-English Words in an English and Non-English words document	mohsen.amiri	Word	3	03-31-2015 11:20 PM
how to write reference into powerpoint graph from excel tab	gulf2014	PowerPoint	0	10-18-2014 06:11 AM
Circular Reference Warning in Excel Sheet.	Rahmat_uk20	Excel	3	06-08-2012 02:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:31 PM.