Excel 2007
- An item name cannot be found. Check that you've typed the name correctly and the item is present in the PivotTable report. ...
- An item name in the formula does not match any of the items in the field. Check the field in the PivotTable report to make ...
- An item name is ambiguous. Another field in the PivotTable report may have an item with the same name. Use the syntax field[item]. ...
- An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver ...
- An unexpected error has occurred during AutoRecover save. It may be possible to AutoRecover a minimal version of the file, ...
- Any data that you do not include in the cube file will not be available to the PivotTable until you reconnect to the server. ...
- Any data that you do not include in the local file cube will not be available to the PivotTable until you reconnect to the ...
- Are you sure that you want to use a | chart type as the default for creating new charts? To use this chart type as the default ...
- Are you sure you want to delete this query? Warning: all data associated with this query will be cleared from this spreadsheet. ...
- array!Converts a vertical range of cells to a horizontal range, or vice versa!is a range of cells on a worksheet or an array ...
- array!Returns the inverse matrix for the matrix stored in an array!is a numeric array with an equal number of rows and columns, ...
- array!Returns the matrix determinant of an array!is a numeric array with an equal number of rows and columns, either a cell ...
- array!Returns the number of columns in an array or reference!is an array or array formula, or a reference to a range of cells ...
- array!Returns the number of rows in a reference or array!is an array, an array formula, or a reference to a range of cells ...
- array,k!Returns the k-th largest value in a data set. For example, the fifth largest number!is the array or range of data ...
- array,k!Returns the k-th percentile of values in a range!is the array or range of data that defines relative standing!is ...
- array,k!Returns the k-th smallest value in a data set. For example, the fifth smallest number!is an array or range of numerical ...
- array,percent!Returns the mean of the interior portion of a set of data values!is the range or array of values to trim and ...
- array,quart!Returns the quartile of a data set!is the array or cell range of numeric values for which you want the quartile ...
- array,row_num,column_num!reference,row_num,column_num,area_num!Returns a value or reference of the cell at the intersection ...
- array,x,sigma!Returns the one-tailed P-value of a z-test!is the array or range of data against which to test X!is the value ...
- array,x,significance!Returns the rank of a value in a data set as a percentage of the data set!is the array or range of data ...
- array1,array2!Returns covariance, the average of the products of deviations for each data point pair in two data sets!is ...
- array1,array2!Returns the correlation coefficient between two data sets!is a cell range of values. The values should be numbers, ...
- array1,array2!Returns the matrix product of two arrays, an array with the same number of rows as array1 and columns as array2!is ...
- array1,array2!Returns the Pearson product moment correlation coefficient, r!is a set of independent values!is a set of dependent ...
- array1,array2!Returns the result of an F-test, the two-tailed probability that the variances in Array1 and Array2 are not ...
- array1,array2,array3,.!Returns the sum of the products of corresponding ranges or arrays!are 2 to 255 arrays for which you ...
- array1,array2,tails,type!Returns the probability associated with a Student's t-Test!is the first data set!is the second data ...
- array_x,array_y!Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays!is the first ...
- array_x,array_y!Sums the differences between the squares of two corresponding ranges or arrays!is the first range or array ...
- array_x,array_y!Sums the squares of the differences in two corresponding ranges or arrays!is the first range or array of ...
- as a picture. This format is better than Bitmap for printing to high quality printers. Also the Picture format takes less ...
- As you change these settings, check the preview chart to make sure you get the look you want. To see more settings, click ...
- At least one field in this PivotTable has Top 10 AutoShow applied. Top 10 filtering has been improved in Excel 2007 so that ...
- At least one item must be showing. If you don't want to show the field at all, cancel the current operation, and then drag ...
- At least one of the changing cells you specified contains a formula. Formulas in changing cells will be replaced by constant ...
- Authentication method used by Excel Calculation Services to retrieve workbook files from all non-Windows SharePoint Services ...
- Autogenerate the title URL for this Web Part that will allow users to click on the Web Part Title Bar to view the current ...
- AutoSort and AutoShow cannot be used with custom calculations that use positional references. Do you want to turn off AutoSort/Show? ...
- AutoSum cannot insert a formula. Select the data for which you want totals and ensure that there is a blank row or column ...
- average_range,criteria_range,criteria,.!Finds average(arithmetic mean) for the cells specified by a given set of conditions ...
- Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose ...
- Because the maximum indentation limit for a cell has been reached, the next field will be displayed in a separate column. ...
- Because the query for this page field does not return any items, the options for the field cannot be changed. If you expected ...
- Because you selected only one cell and the surrounding cells are blank, Microsoft Office Excel cannot determine which cells ...
- Because your source data has automatic subtotals, Microsoft Office Excel cannot create a PivotTable report from it. For information ...
- Before you can add signatures, you must save the workbook in a format that supports digital signatures. Do you want to save ...
- Both the existing name, and name you are attempting to use are currently referenced in cell formulas. Please enter a different ...
- bottom,top!Returns a random number between the numbers you specify!is the smallest integer RANDBETWEEN will return!is the ...
- Breaking links permanently converts formulas and external references to their existing values. Because this cannot be undone, ...
- By default, conversion permanently replaces PivotTable data values, row labels, and column labels by substituting formulas ...
- Calculated totals are not supported by the data provider. The creation of calculated totals requires the data provider to ...
- Calculation mode for all workbooks. Valid values: File (use the setting in the workbook file); Manual, Auto, and AutoDataTables ...
- Can't filter records. The field name specified in the GroupFilterField property must contain values that have the same or ...
- Can't make data connection via this web server. Install the Microsoft Office Server Extensions in order to use data access ...
- Cannot add this entry to the list. An entry corresponding to this key already exists, and duplicate entries are not supported. ...
- Cannot add this entry to the list. An entry corresponding to this key already exists, and duplicate entries are not supported. ...
- Cannot apply a conditional format to a range on multiple sheets or a different sheet than where the current selection is. ...
- Cannot apply a conditional format to a range that has cells outside of a PivotTable data region. Make sure that all the cells ...
- cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document ...
- cannot be merged into the current workbook. Workbooks to be merged must be copies made from the same shared workbook, and ...
- Cannot change the XML mapping for the specified object, because it is already bound to an XML map. Use the Clear method to ...
- Cannot complete operation. Select the entire table, including the total row if present, and then try the operation again. ...
- Cannot complete operation: A table cannot overlap with a PivotTable report, query results, a table, merged cells, or an XML ...
- Cannot complete operation: Operations that include cells both inside and outside a table range or XML mapping, and operations ...
- Cannot complete operation: You are attempting to change a portion of a table row or column in a way that is not allowed. ...
- Cannot complete the requested script operation, because the control was unable to perform security checks. Typically this ...
- Cannot connect to the data source for this Web Part or Spreadsheet control. An unknown error occurred while attempting to ...
- Cannot connect to the data source for this Web Part or Spreadsheet control. The URL specified for the Web Service is invalid. ...
- Cannot connect to the data source for this Web Part or Spreadsheet control. You may not have sufficient permissions to connect ...
- Cannot create a table in the last row of the workbook. A table must have at least two rows, one for the table header, and ...
- Cannot create this table while the AutoFilter command is turned on. Creating a table from a range without headers may cause ...
- Cannot delete "|0". You cannot delete a PageRowSource that has dependent PageRowSources. Delete the dependent PageRowSources ...
- Cannot delete "|0". You cannot delete a RecordsetDef that has dependent RecordsetDefs. Delete the dependent RecordsetDefs ...