Excel 2007

  1. An item name cannot be found. Check that you've typed the name correctly and the item is present in the PivotTable report. ...
  2. 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 ...
  3. An item name is ambiguous. Another field in the PivotTable report may have an item with the same name. Use the syntax field[item]. ...
  4. An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver ...
  5. An unexpected error has occurred during AutoRecover save. It may be possible to AutoRecover a minimal version of the file, ...
  6. Any data that you do not include in the cube file will not be available to the PivotTable until you reconnect to the server. ...
  7. Any data that you do not include in the local file cube will not be available to the PivotTable until you reconnect to the ...
  8. 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 ...
  9. Are you sure you want to delete this query? Warning: all data associated with this query will be cleared from this spreadsheet. ...
  10. 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 ...
  11. array!Returns the inverse matrix for the matrix stored in an array!is a numeric array with an equal number of rows and columns, ...
  12. array!Returns the matrix determinant of an array!is a numeric array with an equal number of rows and columns, either a cell ...
  13. 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 ...
  14. 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 ...
  15. 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 ...
  16. array,k!Returns the k-th percentile of values in a range!is the array or range of data that defines relative standing!is ...
  17. 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 ...
  18. 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 ...
  19. array,quart!Returns the quartile of a data set!is the array or cell range of numeric values for which you want the quartile ...
  20. array,row_num,column_num!reference,row_num,column_num,area_num!Returns a value or reference of the cell at the intersection ...
  21. 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 ...
  22. 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 ...
  23. array1,array2!Returns covariance, the average of the products of deviations for each data point pair in two data sets!is ...
  24. array1,array2!Returns the correlation coefficient between two data sets!is a cell range of values. The values should be numbers, ...
  25. array1,array2!Returns the matrix product of two arrays, an array with the same number of rows as array1 and columns as array2!is ...
  26. array1,array2!Returns the Pearson product moment correlation coefficient, r!is a set of independent values!is a set of dependent ...
  27. array1,array2!Returns the result of an F-test, the two-tailed probability that the variances in Array1 and Array2 are not ...
  28. array1,array2,array3,.!Returns the sum of the products of corresponding ranges or arrays!are 2 to 255 arrays for which you ...
  29. array1,array2,tails,type!Returns the probability associated with a Student's t-Test!is the first data set!is the second data ...
  30. array_x,array_y!Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays!is the first ...
  31. array_x,array_y!Sums the differences between the squares of two corresponding ranges or arrays!is the first range or array ...
  32. array_x,array_y!Sums the squares of the differences in two corresponding ranges or arrays!is the first range or array of ...
  33. as a picture. This format is better than Bitmap for printing to high quality printers. Also the Picture format takes less ...
  34. As you change these settings, check the preview chart to make sure you get the look you want. To see more settings, click ...
  35. At least one field in this PivotTable has Top 10 AutoShow applied. Top 10 filtering has been improved in Excel 2007 so that ...
  36. 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 ...
  37. At least one of the changing cells you specified contains a formula. Formulas in changing cells will be replaced by constant ...
  38. Authentication method used by Excel Calculation Services to retrieve workbook files from all non-Windows SharePoint Services ...
  39. Autogenerate the title URL for this Web Part that will allow users to click on the Web Part Title Bar to view the current ...
  40. AutoSort and AutoShow cannot be used with custom calculations that use positional references. Do you want to turn off AutoSort/Show? ...
  41. AutoSum cannot insert a formula. Select the data for which you want totals and ensure that there is a blank row or column ...
  42. average_range,criteria_range,criteria,.!Finds average(arithmetic mean) for the cells specified by a given set of conditions ...
  43. Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose ...
  44. Because the maximum indentation limit for a cell has been reached, the next field will be displayed in a separate column. ...
  45. Because the query for this page field does not return any items, the options for the field cannot be changed. If you expected ...
  46. Because you selected only one cell and the surrounding cells are blank, Microsoft Office Excel cannot determine which cells ...
  47. Because your source data has automatic subtotals, Microsoft Office Excel cannot create a PivotTable report from it. For information ...
  48. Before you can add signatures, you must save the workbook in a format that supports digital signatures. Do you want to save ...
  49. Both the existing name, and name you are attempting to use are currently referenced in cell formulas. Please enter a different ...
  50. bottom,top!Returns a random number between the numbers you specify!is the smallest integer RANDBETWEEN will return!is the ...
  51. Breaking links permanently converts formulas and external references to their existing values. Because this cannot be undone, ...
  52. Bubble. Compares sets of 3 values. Like a scatter chart with the third value displayed as the size of the bubble marker. ...
  53. By default, conversion permanently replaces PivotTable data values, row labels, and column labels by substituting formulas ...
  54. Calculated totals are not supported by the data provider. The creation of calculated totals requires the data provider to ...
  55. Calculation mode for all workbooks. Valid values: File (use the setting in the workbook file); Manual, Auto, and AutoDataTables ...
  56. Can't filter records. The field name specified in the GroupFilterField property must contain values that have the same or ...
  57. Can't make data connection via this web server. Install the Microsoft Office Server Extensions in order to use data access ...
  58. Cannot add this entry to the list. An entry corresponding to this key already exists, and duplicate entries are not supported. ...
  59. Cannot add this entry to the list. An entry corresponding to this key already exists, and duplicate entries are not supported. ...
  60. Cannot apply a conditional format to a range on multiple sheets or a different sheet than where the current selection is. ...
  61. Cannot apply a conditional format to a range that has cells outside of a PivotTable data region. Make sure that all the cells ...
  62. 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 ...
  63. cannot be merged into the current workbook. Workbooks to be merged must be copies made from the same shared workbook, and ...
  64. Cannot change the XML mapping for the specified object, because it is already bound to an XML map. Use the Clear method to ...
  65. Cannot complete operation. Select the entire table, including the total row if present, and then try the operation again. ...
  66. Cannot complete operation: A table cannot overlap with a PivotTable report, query results, a table, merged cells, or an XML ...
  67. Cannot complete operation: Operations that include cells both inside and outside a table range or XML mapping, and operations ...
  68. Cannot complete operation: You are attempting to change a portion of a table row or column in a way that is not allowed. ...
  69. Cannot complete the requested script operation, because the control was unable to perform security checks. Typically this ...
  70. Cannot connect to the data source for this Web Part or Spreadsheet control. An unknown error occurred while attempting to ...
  71. Cannot connect to the data source for this Web Part or Spreadsheet control. The URL specified for the Web Service is invalid. ...
  72. Cannot connect to the data source for this Web Part or Spreadsheet control. You may not have sufficient permissions to connect ...
  73. 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 ...
  74. Cannot create this table while the AutoFilter command is turned on. Creating a table from a range without headers may cause ...
  75. Cannot delete "|0". You cannot delete a PageRowSource that has dependent PageRowSources. Delete the dependent PageRowSources ...