Excel 2016
- If you modify the query, columns that you deleted from the Excel external data range will reappear as new columns, unless ...
- If you trust the source of this workbook, you can enable automatic query refresh. If you disable automatic query refresh, ...
- If you turn off the Accept Labels In Formulas option, (!idspnExcel_NV) replaces any labels you used in formulas with cell ...
- If you want to track reviewers' changes in this workbook, you need to make this workbook shared. Do you want to save a shared ...
- Import data for an unlisted format by using the Microsoft Query Wizard and ODBC. Functionality is limited for compatibility ...
- In order to create a survey, we will have to move you from the dogfood environment to the production environment. Don't worry, ...
- In order to edit workbooks in this {0:DocumentLibrary} they must first be checked out. To edit this workbook, check out the ...
- Inconsistent formulas are formulas that do not match those in the cells to each side when the formulas in those adjoining ...
- index_num,value1,value2,.!Chooses a value or action to perform from a list of values, based on an index number!specifies ...
- info_type,reference!Returns information about the formatting, location, or contents of the first cell, according to the sheet's ...
- Initialization of the data source failed.Check the database server or contact your database administrator. Make sure the ...
- Initialization of the data source failed.Excel is unable to connect to the specified data source. Create a new connection ...
- Inserts an icon that represents the contents of the file into your document. Changes to the source file will be reflected ...
- Inserts the contents of the file into your document and creates a link to the source file. Changes to the source file will ...
- Inserts the contents of the file into your document so that you can edit it later using the program which created the source ...
- inumber!Returns the absolute value (modulus) of a complex number!is a complex number for which you want the absolute value! ...
- inumber!Returns the hyperbolic cosecant of a complex number!is a complex number for which you want the hyperbolic cosecant! ...
- inumber!Returns the imaginary coefficient of a complex number!is a complex number for which you want the imaginary coefficient! ...
- inumber,number!Returns a complex number raised to an integer power!is a complex number you want to raise to a power!is the ...
- inumber1,inumber2!Returns the difference of two complex numbers!is the complex number from which to subtract inumber2!is ...
- inumber1,inumber2!Returns the quotient of two complex numbers!is the complex numerator or dividend!is the complex denominator ...
- inumber1,inumber2,.!Returns the product of 1 to 255 complex numbers!Inumber1, Inumber2,. are from 1 to 255 complex numbers ...
- is in the |1 file format. Do you want to convert this workbook to the latest format?The new file name will have a new extension. ...
- is not a shared workbook. Reviewers' changes can't be merged into it. You'll need to manually incorporate reviewers' changes. ...
- issue,first_interest,settlement,rate,par,frequency,basis,calc_method!Returns the accrued interest for a security that pays ...
- issue,settlement,rate,par,basis!Returns the accrued interest for a security that pays interest at maturity!is the security's ...
- It is possible that better integer solutions exist. To make sure Solver finds the very best solution, set the integer tolerance ...
- known_ys,known_xs!Calculates the point at which a line will intersect the y-axis by using a best-fit regression line plotted ...
- known_ys,known_xs!Returns the slope of the linear regression line through the given data points!is an array or cell range ...
- known_ys,known_xs!Returns the square of the Pearson product moment correlation coefficient through the given data points!is ...
- known_ys,known_xs!Returns the standard error of the predicted y-value for each x in a regression!is an array or range of ...
- known_ys,known_xs,const,stats!Returns statistics that describe a linear trend matching known data points, by fitting a straight ...
- known_ys,known_xs,const,stats!Returns statistics that describe an exponential curve matching known data points!is the set ...
- known_ys,known_xs,new_xs,const!Returns numbers in a linear trend matching known data points, using the least squares method!is ...
- known_ys,known_xs,new_xs,const!Returns numbers in an exponential growth trend matching known data points!is the set of y-values ...
- Limits the number of integer solutions found by the Branch & Bound algorithm, or the Evolutionary engine, before Solver pauses ...
- Limits the number of subproblems explored by the Branch & Bound algorithm, or the Evolutionary engine, before Solver pauses ...
- Limits the time taken by the solution process by limiting the number of interim calculations. While you can enter a value ...
- Limits the time taken by the solution process. While you can enter a value as high as 32,767, the default value of 100 (seconds) ...
- Line with MarkersDisplay trend over time (dates, years) or ordered categories.Useful when there are only a few data points. ...
- LineDisplay trend over time (dates, years) or ordered categories.Useful when there are many data points and the order is ...
- Links to '|' were not updated because '|' was not recalculated before it was last saved. To update links with current values ...
- link_location,friendly_name!Creates a shortcut or jump that opens a document stored on your hard drive, a network server, ...
- Location reference is not valid because the cells are not all in the same column or row. Select cells that are all in a single ...
- Locking cells or hiding formulas has no effect until you protect the worksheet (Review tab, Changes group, Protect Sheet ...
- Locking objects has no effect unless the sheet is protected. To help protect the sheet, choose Format on the Home tab, and ...
- Locking objects has no effect unless the sheet is protected.To help protect the sheet, choose Format on the Home tab, and ...
- logical1,logical2,.!Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE!are 1 to 255 conditions ...
- logical1,logical2,.!Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments ...
- logical1,logical2,.!Returns a logical 'Exclusive Or' of all arguments!are 1 to 254 conditions you want to test that can be ...
- logical_test,value_if_true,value_if_false!logical_test!Checks whether a condition is met, and returns one value if TRUE, ...
- lookup_value,lookup_array,match_type!Returns the relative position of an item in an array that matches a specified value ...
- lookup_value,table_array,col_index_num,range_lookup!Looks for a value in the leftmost column of a table, and then returns ...
- lookup_value,table_array,row_index_num,range_lookup!Looks for a value in the top row of a table or array of values and returns ...
- lower_limit,upper_limit!Returns the error function!is the lower bound for integrating ERF!is the upper bound for integrating ...
- Macro-enabled file extensions (|) cannot be used with macro-free files. Change the file extension in the File Name text box ...
- Macros are disabled because the security level is set to High and a digitally signed Trusted Certificate is not attached ...
- Macros are disabled because the security level is set to Very High. To run the macros, change the security level to a lower ...
- macro_name,description,menu_on,menu_text,shortcut_on,shortcut_key,function_category,status_bar_text,help_id,help_file,argument_description ...
- Make sure that the size of the provided array matches the dimensions of the destination range (for example, 2 columns wide ...
- may contain features that are not compatible with this format. Do you want to continue to save in this format?For more information ...
- Members of this group can view pages, list items, and documents. If the document has a server rendering available, they can ...
- Memory was used up attempting to convert and save PivotTable report data from a different version.Data for the saved PivotTable ...
- Microsoft Excel isn't currently your default program for viewing and editing spreadsheets. Do you want to select file types ...
- Microsoft Excel workspaces cannot contain Microsoft Excel 4.0 workbooks. Click Save As, then select (!idspnExcel_NV) Workbook ...
- Microsoft Graph can not import all of the number formats. All of the number formats have not been applied to the datasheet. ...
- Microsoft Graph cannot access the file '|'. There are several possible reasons: The file name or path name does not exist. ...
- Microsoft Graph cannot open any more documents because there is not enough available memory or disk space. To make more memory ...
- Microsoft Graph cannot send data to | or update the chart. What do you want to do?* To return to the main program without ...
- Microsoft Graph cannot use the number format you typed.Try using one of the built-in number formats. For more information ...
- Microsoft Graph was unable to bring up the network dialog box. The problem may be a lack of available memory, or the network ...
- Microsoft is a registered trademark of Microsoft Corporation. Windows is a registered trademark of Microsoft Corporation. ...
- Microsoft Query cannot modify this query. The query was created using an OLE DB data source driver that Query cannot support. ...
- Microsoft Query could not be started because it isn't installed. You can install Query by running the installation program ...
- Microsoft Query does NOT encrypt your password when saving it in the data source definition. It will be visible to anyone ...