Excel 2007

  1. database,field,criteria!Extracts from a database a single record that matches the conditions you specify!is the range of ...
  2. database,field,criteria!Multiplies the values in the field (column) of records in the database that match the conditions ...
  3. database,field,criteria!Returns the largest number in the field (column) of records in the database that match the conditions ...
  4. database,field,criteria!Returns the smallest number in the field (column) of records in the database that match the conditions ...
  5. data_array,bins_array!Calculates how often values occur within a range of values and then returns a vertical array of numbers ...
  6. data_field,pivot_table,field,item,.!Extracts data stored in a PivotTable.!is the name of the data field to extract data from!is ...
  7. Date formats display date and time serial numbers as date values. Date formats that begin with an asterisk (*) respond to ...
  8. date_text!Converts a date in the form of text to a number that represents the date in Microsoft Office Excel date-time code!is ...
  9. decimal_dollar,fraction!Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction!is ...
  10. DeepPink\0Magenta\0Fuchsia\0Violet\0BlueViolet\0Plum\0Orchid\0Thistle\0MediumOrchid\0DarkViolet\0DarkOrchid\0MediumViole ...
  11. Defined names or formulas in this workbook may display different values when they are recalculated in an earlier version ...
  12. Deleting the Default chart type will reset it to the original default type. Do you want to continue deleting the Default ...
  13. destination_ref,data_type,text_delim,consecutive_delim,tab,semicolon,comma,space,other,other_char,field_info,decimal_separator,thousands_separator ...
  14. Determine whether encrypted communication is required between client computers and front-end components of Excel Services. ...
  15. Display error indicators and enable error correction for cells containing values that are inconsistent with the column data ...
  16. Display error indicators and enable error correction for cells that contain dates in text form that lack four digit years. ...
  17. Display error indicators and enable error correction for cells that contain formulas or values inconsistent with the column ...
  18. Display error indicators and enable error correction for cells that contain formulas, but which are unlocked and editable ...
  19. Display error indicators and enable error correction for cells that contain numbers that are stored as their textual representation ...
  20. Display error indicators and enable error correction for formulas that result in an error value such as #VALUE! or #DIV/0! ...
  21. Do you want to save the changes to '|'? Microsoft Office Excel recalculates formulas when opening files last saved by an ...
  22. Do you want to save the changes you made to the Personal Macro Workbook? If you click Yes, the macros will be available the ...
  23. Do you want to update the chart in |? To update the chart, click Yes. To close without updating the chart, click No. To cancel ...
  24. Don't ask me to refresh any data connections again. Instead refresh when I perform an operation and the specified period ...
  25. Each chart type has two or more subtypes from which you can choose. To see what your data will look like when you use the ...
  26. Each custom type is based on a standard type. The custom chart type also includes display settings and custom formatting ...
  27. Earlier versions of Excel do not support color formatting in header and footer text. The color formatting information will ...
  28. Earlier versions of Excel only support line colors from the color palette. When the workbook is opened in an earlier version ...
  29. Edit the color palette used when this workbook is opened in previous versions of Excel. When a file created in Excel 2007 ...
  30. effect_rate,npery!Returns the annual nominal interest rate!is the effective interest rate!is the number of compounding periods ...
  31. Embedding of smart tags is turned off for this workbook. Smart tags that have been recognized will not be saved. Would you ...
  32. Enables or disables hyperlinks to locations in the workbook, Web pages, or other documents. To follow hyperlinks to locations ...
  33. Enables or prevents Excel Web Access from performing a periodic refresh of an external data source with an interval defined ...
  34. Enter a contiguous range such as "A1:B7" or "A1" or "MyTable[#Data]" instead of a noncontiguous range such as "A1:B7, B12" ...
  35. Enter a number of columns. That number of columns appears when a user pages up, down, left, or right when using a workbook. ...
  36. Enter a range reference using A1 notation such as "Sheet1!A6:A15" or a valid structured reference such as "ShippingData[#Headers],[Ship ...
  37. Enter an amount here if you want to make additional principal payments every pay period. For occasional extra payments, enter ...
  38. Enter the address for the Web page that contains the data you want. If browsing, switch back to Excel once you have located ...
  39. Error checking is complete. No more validation errors have been found. To submit your changes to Windows SharePoint Services, ...
  40. Errors were detected in '|', but Microsoft Office Excel was able to save the file by removing or repairing the features listed ...
  41. Errors were detected while saving '|'. Microsoft Office Excel may be able to save the file by removing or repairing some ...
  42. error_val!Returns a number matching an error value.!is the error value for which you want the identifying number, and can ...
  43. Excel can not sign VBA macros when saving to this file format. Do you want to remove the digital signature and continue saving ...
  44. Excel can perform checks while opening the workbook and attempt to repair any corruption it detects, or extract just the ...
  45. Excel cannot access the source data for the chart. The source data may be missing or may not match the values used in the ...
  46. Excel cannot complete this task with available resources. Choose less data or close other applications. Continue without ...
  47. Excel cannot connect to your database with the driver you specified in your data source. The driver does not support OLAP-provider ...
  48. Excel cannot convert this PivotTable report because a filter has been applied and there are member properties on that axis. ...
  49. Excel cannot convert this PivotTable report because conversion would result in a formula that is too long for Excel to handle. ...
  50. Excel cannot convert this PivotTable report because the PivotTable report contains one or more custom groups. Remove the ...
  51. Excel cannot convert this PivotTable report because there are too many items selected in the report filter. Either reduce ...
  52. Excel cannot convert this PivotTable report to formulas because a filter has been applied and one or more dimensions on that ...
  53. Excel cannot convert this PivotTable report, either because there is not enough memory or because the PivotTable report was ...
  54. Excel cannot convert to formulas because one or more filtered fields are not completely visible. To make the filtered fields ...
  55. Excel cannot display this PivotTable report. The row area has more than 65,536 items, or the column area has more than 16,384 ...
  56. Excel cannot find OLAP cube |. Either the OLAP database has been changed or you don't have permissions to connect to the ...
  57. Excel cannot find the text file to refresh this external data range. Check to make sure the text file has not been moved ...
  58. Excel cannot group by numeric or date intervals in fields with blank or missing data. Grouping information for some fields ...
  59. Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source ...
  60. Excel cannot load more than 65,500 cell formulas per sheet that have defined name or off-sheet references; additional formulas ...
  61. Excel cannot load the information used to connect to the server running Windows SharePoint Services. In order to edit this ...
  62. Excel cannot merge another file that is already open or has the same name as the current file. To merge a file copied from ...
  63. Excel cannot open Access .mdb files directly. To import Access data into Excel, use the Get External Data command: In Excel, ...
  64. Excel cannot open FoxPro .dbc files. To import FoxPro data into Excel, use the Get External Data command: In Excel, click ...
  65. Excel cannot open the file '|' because the file format or file extension is not valid. Verify that the file has not been ...
  66. Excel cannot open this file. The encryption type used is not available, contact the author of the file. More encryption types ...
  67. Excel cannot open this Quattro Pro for Windows file. The Quattro Pro Converter may not be installed or the file type may ...
  68. Excel cannot open this query file because it includes features that are only available in a later version of the product. ...
  69. Excel cannot publish a range from sheet | because the range became invalid. Choose "Range of cells" and specify the cells ...
  70. Excel cannot publish the chart interactively because a range in the source data is not a single, contiguous (rectangular) ...
  71. Excel cannot publish the range | because the range refers to cells that are not in a single, contiguous (rectangular) range. ...
  72. Excel cannot publish to the specified file because it is not in the expected format (a Web Page that includes a tag). Or, ...
  73. Excel cannot save the file to this location. To save the changes and avoid losing data in your file, click the Microsoft ...
  74. Excel cannot update one or more links in this workbook. To update the links, open all the link source files (click Edit Links ...
  75. Excel cannot verify that unsynchronized changes are authorized. Synchronize your changes with the server and try saving again. ...