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