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