Advanced Settings
Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.
This dialog box from the Table Import Wizard enables you to specify the encoding and the locale for the flat file you are connecting to. To access the wizard from the PowerPivot window, on the Home tab, in the Get External Data group, click the type of data source from which you want to import tables.
Term |
Definition |
Encoding |
Specify the type of encoding to use: ANSI or Unicode. The Unicode value corresponds to UTF-16 encoding. |
Locale |
Specify the locale to provide language-specific information for ordering and for date and time formats. |