Excel 2007

  1. spell_lang,user_dict,suggest_main_only,ignore_caps,ignore_mixed_digits,ignore_file_names,grmn_use_postreform,kor_combine ...
  2. start_date,days,holidays!Returns the serial number of the date before or after a specified number of workdays!is a serial ...
  3. start_date,end_date,basis!Returns the year fraction representing the number of whole days between start_date and end_date!is ...
  4. start_date,end_date,holidays!Returns the number of whole workdays between two dates!is a serial date number that represents ...
  5. start_date,end_date,method!Returns the number of days between two dates based on a 360-day year (twelve 30-day months)!start_date ...
  6. start_date,months!Returns the serial number of the date that is the indicated number of months before or after the start ...
  7. start_date,months!Returns the serial number of the last day of the month before or after a specified number of months!is ...
  8. Stop the open operation on a file in this location under the following circumstances: The file contains a Refresh on Open ...
  9. Stop the open operation on a workbook under the following circumstances: The workbook contains a Refresh on Open data connection ...
  10. Strong name or full path of an assembly that contains user-defined functions, which Excel Calculation Services can call. ...
  11. Strong name or full path of an assembly that contains user-defined functions, which Excel Calculation Services can call. ...
  12. sum_range,criteria_range,criteria,.!Adds the cells specified by a given set of conditions or criteria!are the actual cells ...
  13. Tables are storage units within the database. If you specify a default table, the Query Wizard initially displays all fields ...
  14. Text values in formulas are limited to 255 characters. To create text values longer than 255 characters in a formula, use ...
  15. text!Changes full-width (double-byte) characters to half-width (single-byte) characters. Use with double-byte character sets ...
  16. text!Changes half-width (single-byte) characters within a character string to full-width (double-byte) characters. Use with ...
  17. text!Converts a text string that represents a number to a number!is the text enclosed in quotation marks or a reference to ...
  18. text!Converts a text string to all uppercase letters!is the text you want converted to uppercase, a reference or a text string! ...
  19. text!Converts a text string to proper case; the first letter in each word in uppercase, and all other letters to lowercase!is ...
  20. text!Converts all letters in a text string to lowercase!is the text you want to convert to lowercase. Characters in Text ...
  21. text!Removes all nonprintable characters from text!is any worksheet information from which you want to remove nonprintable ...
  22. text!Removes all spaces from a text string except for single spaces between words!is the text from which you want spaces ...
  23. text!Returns a numeric code for the first character in a text string, in the character set used by your computer!is the text ...
  24. text!Returns the number of characters in a text string!is the text whose length you want to find. Spaces count as characters! ...
  25. text!Returns the number of characters in a text string. Use with double-byte character sets (DBCS)!is the text whose length ...
  26. text,number_times!Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string!is ...
  27. text,num_bytes!Returns the specified number of characters from the end of a text string. Use with double-byte character sets ...
  28. text,num_bytes!Returns the specified number of characters from the start of a text string. Use with double-byte character ...
  29. text,num_chars!Returns the specified number of characters from the end of a text string!is the text string that contains ...
  30. text,num_chars!Returns the specified number of characters from the start of a text string!is the text string containing the ...
  31. text,old_text,new_text,instance_num!Replaces existing text with new text in a text string!is the text or the reference to ...
  32. text,start_num,num_bytes!Returns characters from the middle of a text string, given a starting position and length. Use with ...
  33. text,start_num,num_chars!Returns the characters from the middle of a text string, given a starting position and length!is ...
  34. text1,text2!Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive!is the ...
  35. text1,text2,.!Joins several text strings into one text string!are 1 to 255 text strings to be joined into a single text string ...
  36. That command cannot be performed on a protected sheet because the source data for this PivotTable report requires a data ...
  37. That command cannot be performed while a protected sheet contains another PivotTable report based on the same source data. ...
  38. That command cannot be used with selections that contain entire rows or columns, and also other cells. Try selecting only ...
  39. That control can only be used while the worksheet is displayed in a separate window. Do you want to open a window for the ...
  40. That workbook cannot be merged because it contains changes that have not been merged followed by later changes that have ...
  41. The action cannot be completed in Compatibility Mode. To complete the action, you can select less data or save the workbook ...
  42. The authentication method used by Excel Calculation Services to retrieve workbook files from all non-Windows SharePoint Services ...
  43. The autoshow setting for custom group field '|0' could not be loaded. Autoshow setting on a custom group field is not supported. ...
  44. The calculated field could not be deleted because insufficient memory is available. Simplify the PivotTable report, or close ...
  45. The calculation mode of workbooks in Excel Calculation Services. All of the settings except the File setting override the ...
  46. The cell or chart that you are trying to change is protected and therefore read-only. To modify a protected cell or chart, ...
  47. The change history for this workbook is corrupt. Unless the workbook is removed from shared use, Excel may not be able to ...
  48. The changes you made to this query, such as choosing a different data object or changing columns, have altered the original ...
  49. The Channel Definition File (CDF) for the Web site contains Web pages with inconsistent offline types. Each Web page must ...
  50. The Chart Data Range is too complex to be displayed. If a new Data Range is selected, it will replace all of the series on ...
  51. The chart name that you specified contains characters that cannot be used. Use any character in a chart name except a colon ...
  52. The chart name you specified cannot be used. You can use any character in a chart name except a colon (:), backslash (\), ...
  53. The column width that you have selected is wider than a page. If you continue, Page Layout View will be unable to correctly ...
  54. The column you selected is not in the original selected range. Either select a column in the original selected range, or ...
  55. The column you selected is not in the original selected range. Either select a column in the original selected range, or ...
  56. The command could not be completed because you are attempting to filter on a cell in the table header. Select a cell in the ...
  57. The command could not be completed because you are attempting to filter on a total row cell. Select a cell in the table's ...
  58. The command could not be completed because you are attempting to filter on the filter header. Select a single cell in the ...
  59. The command could not be completed by using the range specified. Select a single cell within the range and try the command ...
  60. The Commands and Options dialog box cannot be displayed from a Microsoft Office 2003 Web Component that is in a modal dialog ...
  61. The Commands and Options dialog box cannot be displayed from a Microsoft Office Web Component that is in a modal dialog or ...
  62. The Commands and Options dialog box cannot be displayed. The Commands and Options dialog box display protection is currently ...
  63. The Compare and Merge operation cannot be completed because some parts of the document being merged from could not be read. ...
  64. The conditionally filtered field '|0' appears between the conditionally filtered field '|1' and its filter context '|2'. ...
  65. The connection in this workbook will no longer be identical to the connection defined in the external file located at '|'. ...
  66. The credentials for a default Windows account that Excel Calculation Services uses for connecting to data sources that require ...
  67. The current operation cannot be completed. Possible reasons include: You attempted to drill down from the lowest level of ...
  68. The current selection includes one or more calculated members that cannot be manually filtered. To apply the filter to the ...
  69. The current selection is not within a refreshable region of the workbook. Select a refreshable region, such as a PivotTable, ...
  70. The custom group field '|0' appears between the Top/Bottom filtered field '|1' and its filter context '|2'. Fields between ...
  71. The data in one or more mapped XML lists exceeds the maximum limit. Open the XML Spreadsheet in Excel and reduce the amount ...
  72. The data in the fields you drag to the ROW and COLUMN areas become the row and column labels of your PivotTable report. When ...
  73. The data mapped on this worksheet is associated with one or more bindings that might also be mapped onto other worksheets. ...
  74. The data range is too complex to be displayed. If a new range is selected, it will replace all of the series in the Series ...
  75. The data retrieval services adapter retrieving your data had an unrecoverable error. Contact product support to determine ...