Excel 2007

  1. To save as XML Spreadsheet, you must have at least one worksheet in this workbook. Chart sheets, MS Excel 4.0 Macro sheets, ...
  2. To save this web page to the current location, it needs to be saved using short file names, which requires organizing supporting ...
  3. To select a column, click the button to the right of the text box, select a column or cell within the column, and then click ...
  4. To sort a column, click the button to the right of the text box, select a column or cell within the column, and then click ...
  5. To sort a row, click the button to the right of the text box, select a row or cell within the row, and then click the button ...
  6. To specify the data and labels for the chart now, click in the Data Range box, and then select the cells on your worksheet. ...
  7. To use a chart template, you can choose it when you create a chart (Insert menu, All Chart Types Dialog Box Launcher, Templates ...
  8. To use an Office Data Connection (.odc) file, click Cancel, and then click Existing Connections in the Get External Data ...
  9. To use multiple chart types, choose the Chart Type command or the chart type group command (for example, Line Group) from ...
  10. To use this feature, you must first refresh the PivotTable. On the Options tab, in the Data group, click Refresh, and then ...
  11. To use this Web page interactively, you must have Microsoft Internet Explorer 5.01 Service Pack 2 (SP2) or later and the ...
  12. To view the columns for data in a table, click the + sign beside it the Available Tables And Columns box. To include an available ...
  13. Top/Bottom filtering context field can not be a custom group field. You are trying to remove field '|0', which will leave ...
  14. Totals in this PivotTable list do not include data that is hidden by filtering. When you export this PivotTable list to Microsoft ...
  15. Totals in this PivotTable list include data that is hidden by filtering. When you export this PivotTable list to Microsoft ...
  16. trials,probability_s,alpha!Returns the smallest value for which the cumulative binomial distribution is greater than or equal ...
  17. Try the following: Switch to the Query window, make sure it isn't waiting to receive data, and then close any open dialog ...
  18. Type or select a worksheet range that contains data you want to summarize, and then click Add. Repeat for each range you ...
  19. Types of external data connections that are allowed. Valid values: None (data connections are not allowed); Dcl (only connections ...
  20. type_text!Returns information about the current operating environment!is text specifying what type of information you want ...
  21. Unable to retrieve external data for the following connections: {0} The data sources may be unreachable, may not be responding, ...
  22. Unauthorized reproduction or distribution of this program, or any portion of it, may result in severe civil and criminal ...
  23. Unexpected file lock by |. Please try again, and then if necessary, use the Share Workbook command (Changes group on the ...
  24. Unexpected file lock by |. You can override this file lock, or continue without doing so. If you continue without overriding ...
  25. Uninitialized ActiveX controls cannot be transferred to the selected file format. The controls will be lost if you continue. ...
  26. Use a color to represent the smallest values in a range. For example, you could represent the bottom 10% of values as blue. ...
  27. Use graduated colors to indicate absolute values. Graduate evenly between the smallest value and 0 (or the value you indicate) ...
  28. Use two colors to distinguish between values smaller than 0 (or the value you indicate) and larger than 0 (or the value you ...
  29. Valid values: from -1 (no timeout) through 2073600 (24 days). 0 means that the session expires at the end of a single request. ...
  30. Valid values: from -1 (short session timeout is disabled) through 2073600 (24 days). 0 means that the session expires at ...
  31. Validation Load Error: For Type |0, Both the and tags were missing. This is invalid because no lower bound was specified ...
  32. Validation Load Error: For Type |0, Both the and tags were missing. This is invalid because no upper bound was specified ...
  33. Validation Load Error: For Type |0, the absence of a tag implies relative cell references in the list values which is not ...
  34. Validation Load Error: For Type |0, |1 was specified as the value of the enumerated list under the tag and is not permitted. ...
  35. Validation Load Error: For Type |0, |1 was specified in the tag and is not recognized as a valid range or list of ranges ...
  36. Validation Load Error: For Type |0, |1 was specified in the tag and |2 was specified in the tag. The Min and Max values define ...
  37. Validation Load Error: In the XML definition of this spreadsheet, the DataValidation element for Range |0 contains the following ...
  38. Validation Load Error: In the XML definition of this spreadsheet, the DataValidation element for Range |0 contains the following ...
  39. value!Checks whether a reference is to an empty cell, and returns TRUE or FALSE!is the cell or a name that refers to the ...
  40. value!Checks whether a value is #N/A, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
  41. value!Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE!is the value you want to test. ...
  42. value!Checks whether a value is a number, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
  43. value!Checks whether a value is a reference, and returns TRUE or FALSE!is the value you want to test. Value can refer to ...
  44. value!Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE!is ...
  45. value!Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns ...
  46. value!Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE!is the value you want tested: ...
  47. value!Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not!is ...
  48. value!Checks whether a value is text, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
  49. value!Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero)!is the value you ...
  50. value!Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; ...
  51. value,format_text!Converts a value to text in a specific number format!is a number, a formula that evaluates to a numeric ...
  52. value,value_if_error!Returns value_if_error if expression is an error and the value of the expression itself otherwise!is ...
  53. value1,value2,.!Calculates standard deviation based on an entire population, including logical values and text. Text and ...
  54. value1,value2,.!Calculates variance based on the entire population, including logical values and text. Text and the logical ...
  55. value1,value2,.!Counts the number of cells in a range that are not empty!are 1 to 255 arguments representing the values and ...
  56. value1,value2,.!Counts the number of cells in a range that contain numbers!are 1 to 255 arguments that can contain or refer ...
  57. value1,value2,.!Estimates standard deviation based on a sample, including logical values and text. Text and the logical value ...
  58. value1,value2,.!Estimates variance based on a sample, including logical values and text. Text and the logical value FALSE ...
  59. value1,value2,.!Returns the average (arithmetic mean) of its arguments, evaluating text and FALSE in arguments as 0; TRUE ...
  60. value1,value2,.!Returns the largest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, ...
  61. value1,value2,.!Returns the smallest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, ...
  62. values,dates,guess!Returns the internal rate of return for a schedule of cash flows!is a series of cash flows that correspond ...
  63. values,finance_rate,reinvest_rate!Returns the internal rate of return for a series of periodic cash flows, considering both ...
  64. values,guess!Returns the internal rate of return for a series of cash flows!is an array or a reference to cells that contain ...
  65. Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly ...
  66. Verify that each of the columns listed below is associated with the correct data type. If a column is associated with an ...
  67. Visual Basic macro modules are now edited in the Visual Basic Editor, not the workbook. To see your modules, click Visual ...
  68. Web browsers display alternative text while pictures are loading or if they are missing. Web search engines use alternative ...
  69. Web page |0 is unavailable offline. To make this page available offline, connect to the Internet, click the Favorites menu, ...
  70. What do you want to do? To return the chart and data to your document before closing Microsoft Graph, click Yes. *To close ...
  71. When automatic calculation is enabled, Excel recalculates the workbook automatically each time a value affecting a formula ...
  72. When calling SetData on a PivotTable, you must use a constant from ChartPivotDataReferenceEnum when using chDimSeriesNames ...
  73. When specifying a sheet in both the range and sheet arguments, ensure that the sheet names are the same. For example, Calculate(Sheet1, ...
  74. While renaming a sheet, you entered an invalid name. Make sure the name does not exceed 31 characters. Make sure the name ...
  75. with complete Microsoft Office Excel formatting. If the object is an OLE control, this includes all extended properties of ...