We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Microsoft has ended support for older versions of IE. For the best experience, upgrade to the latest version of IE, or view this page in another browser.
On the Data tab in Excel: Select From Other Sources -> From Analysis Services.
Enter the Server name and click Next.
Select the OLAP Server database and Cube that you want to use and click Next.
In theFile Name, click Browse... -> Copy the path from the address bar, for example 'C:\Users\[username]\Documents\My Data Sources'. Click Save, Finish and OK.
By using Windows Explorer, open the path copied from the address bar (as pointed in step 4) and locate the *.odc file in the directory. Then open this file in Notepad.
At the end of the <odc:ConnectionString>node, you can find “Locale Identifier=[code]”
On the Data tab, click Existing Connections, locate the edited connection file and click Open. This connection uses the new Locale setting.
Did you find this information helpful?
Help us improve!
Correct inaccurate or outdated content
Improve illustrations or images
Fix typos or broken links/images
Add more information
Correct inaccurate or outdated code samples
I agree to the creation of a Syncfusion account in my name and to be contacted regarding this message. No further action will be taken. Please see our Privacy policy and Cookie Policy.
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.