Excel 2013

  1. function_num,ref1,.!Returns a subtotal in a list or database!is the number 1 to 11 that specifies the summary function for ...
  2. Generates a list of all cells that have dependent cells. Changing the value of any cell on this list would change the value ...
  3. Generates a list of cells containing any formula with a numeric constant as part of its formula. For example, =SUM(A3:B7)*25.2 ...
  4. Generates a list of cells containing any formula with a textual constant as part of its formula. For example, ="Hello world" ...
  5. Generates a list of cells containing array formulas. On the spreadsheet, Excel will show arrays formulas with surrounding ...
  6. Generates a list of cells containing duplicate formulas. Duplicate formulas are formulas that are duplicated one or more ...
  7. Generates a list of cells containing formulas that are inconsistent with its neighboring cells. For example, if a row is ...
  8. Generates a list of cells containing formulas that do not refer to other cells. For example, the formula: '=5*2' does not ...
  9. Generates a list of cells containing formulas that produce a date/time value. For example, the formula: '=NOW()' will produce ...
  10. Generates a list of cells containing formulas that produce a logical value. For example, the formula: '=TRUE' produces a ...
  11. Generates a list of cells containing formulas that produce a numeric value. For example, the formula: '=SUM(A1:C1)' will ...
  12. Generates a list of cells containing formulas that produce a textual value. For example, the formula: '="Today is "&TEXT(NOW(),"dddd")' ...
  13. Generates a list of cells containing formulas that refer to blank cells as part of its calculation range. A blank cell is ...
  14. Generates a list of cells containing formulas that refer to external workbooks in their formulas. For example, a formula ...
  15. Generates a list of cells containing formulas that refer to hidden cells as part of its calculation range. A hidden cell ...
  16. Generates a list of cells containing formulas that refer to textual cells as part of its calculation range. A textual cell ...
  17. Generates a list of cells containing formulas that start with a '+' character. For example, a formula such as: '=+B25' is ...
  18. Generates a list of cells containing formulas that start with a '-' character. For example, a formula such as: '=-B25' is ...
  19. Generates a list of cells containing formulas with errors. On the spreadsheet, Excel will show the value of these cells as ...
  20. Generates a list of cells containing formulas with nested IF() statements. This is an IF() statement inside of another IF() ...
  21. Generates a list of cells containing numeric values that have been formatted as text. This will also include values that ...
  22. Generates a list of cells containing text that looks like a formula (starts with an equals sign), but is formatted as text ...
  23. Generates a list of cells containing unique formulas. Unique formulas are formulas that exist only once within the workbook, ...
  24. Generates a list of cells that are not blank, and the foreground and background color have been formatted to the same color. ...
  25. Generates a list of non-formula cells with a numeric value. For example, a cell with a constant value of '27.5' would be ...
  26. Generates a list of non-formula cells with a textual value. For example, a cell with a constant value of 'Financials' would ...
  27. Generates a summary of the current workbook, including totals for items such as: Number of Formulas, Number of Formulas With ...
  28. Graph requires the file OLEAUT32.DLL to run. The version on your machine doesn't match this version of Graph. Please re-run ...
  29. Graph was previously unable to load your toolbar customizations. Would you like to reset your toolbars to their default state? ...
  30. Grouping is applied to one or more fields of this PivotTable. What-If Analysis cannot be enabled when grouping is applied. ...
  31. hour,minute,second!Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time ...
  32. Hyperlinks in hyperlink fields must use protocols supported by (!idspnSharePointFoundation_NV). Some protocols, such as telnet ...
  33. idspnExcel_NV) can convert only one column at a time. The range can be many rows tall but no more than one column wide. Try ...
  34. idspnExcel_NV) cannot access the file '|'. There are several possible reasons: The file name or path does not exist. The ...
  35. idspnExcel_NV) cannot calculate a formula. Cell references in the formula refer to the formula's result, creating a circular ...
  36. idspnExcel_NV) cannot calculate a formula. Cell references in the formula refer to the formula's result, creating a circular ...
  37. idspnExcel_NV) cannot calculate a formula. There is a circular reference in an open workbook, but the references that cause ...
  38. idspnExcel_NV) cannot complete this operation because the ODBC Driver Manager is not installed. To install the ODBC Driver ...
  39. idspnExcel_NV) cannot create or use the data range reference because it is too complex. Try one or more of the following: ...
  40. idspnExcel_NV) cannot determine which row in your list or selection contains column labels, which are required for this command. ...
  41. idspnExcel_NV) cannot determine which row in your list or selection contains column labels, which are required for this command. ...
  42. idspnExcel_NV) cannot display some of the graphics in this file because the | graphics filter is not installed. To display ...
  43. idspnExcel_NV) cannot find '|0' on '|1'. There are two possible reasons: The name you specified may not be defined. The name ...
  44. idspnExcel_NV) cannot make this change because there are too many row or column items. Remove at least one row or column ...
  45. idspnExcel_NV) cannot move the page break because doing so would reduce the scale to below the minimum 10 percent. To print ...
  46. idspnExcel_NV) cannot open or save any more documents because there is not enough available memory or disk space. To make ...
  47. idspnExcel_NV) cannot perform this action on nonadjacent cells. To complete the task, select one area at a time, and try ...
  48. idspnExcel_NV) cannot save AutoRecover info to |. Check the network connection or change the location on the Save tab of ...
  49. idspnExcel_NV) cannot save this workbook because the control named | does not support saving. To save the workbook, delete ...
  50. idspnExcel_NV) cannot use CHART.XLT. To add this chart to your list of custom chart formats, save it as a chart template ...
  51. idspnExcel_NV) cannot use the number format you typed.Try using one of the built-in number formats.For more information about ...
  52. idspnExcel_NV) could not open or read this query file. Either the file has been damaged or the file format is not valid. ...
  53. idspnExcel_NV) found a row of data immediately above your table or database. If the row contains column labels, you should ...
  54. idspnExcel_NV) has detected that your computer has a version of Adobe Acrobat PDFMaker that is known to cause instabilities ...
  55. idspnExcel_NV) is placing the PivotTable report on a new sheet, so that it won't overwrite existing data in your workbook. ...
  56. idspnExcel_NV) may not be able to properly open the XML Spreadsheet file you have saved, because at least one sheet contains ...
  57. idspnExcel_NV) requires file OLEAUT32.DLL to run. The version of OLEAUT32.DLL that is on your computer is older than the ...
  58. idspnExcel_NV) turned off the background query option so that the macro you recorded can run correctly. For more information, ...
  59. idspnExcel_NV) turned off the background query option, so that the macro you recorded will run correctly. For more information, ...
  60. idspnExcel_NV) was attempting to open and repair the file. To start this process again, choose Open and Repair from the Open ...
  61. If enabled and task pane applications exist in the workbook, a collapsible pane will appear where users can access these ...
  62. If enabled and workbook parameters exist in the workbook, a collapsible pane will appear where users can edit these parameters. ...
  63. If one or more fields in the PivotTable have calculated items, no fields can be used in the data area two or more times, ...
  64. If the preview chart looks the way you want, the data range is already correct.To change the data and labels for the chart, ...
  65. If the user you selected is currently editing the workbook, this action will prevent the user from saving the workbook, and ...
  66. If the value in a PivotTable cell is affected by two or more calculated items, the value is determined by the last formula ...
  67. If you already specified the data for the chart on the Data Range tab, the ranges, names, and labels are correct.However, ...
  68. If you change this option, (!idspnExcel_NV) will erase the history of changes to this workbook. Users will no longer be able ...
  69. If you deactivate this relationship, any PivotTables, PivotCharts, external data ranges, as well as cube functions which ...
  70. If you delete this relationship, any PivotTables, PivotCharts, external data ranges, as well as cube functions which combine ...
  71. If you modify the MDX definition, any additional modifications can only be done using MDX as well. Click OK to modify the ...
  72. If you modify the query, columns that you deleted from the Excel external data range will reappear as new columns, unless ...
  73. If you trust the source of this workbook, you can enable automatic query refresh. If you disable automatic query refresh, ...
  74. If you turn off the Accept Labels In Formulas option, (!idspnExcel_NV) replaces any labels you used in formulas with cell ...
  75. If you want to track reviewers' changes in this workbook, you need to make this workbook shared. Do you want to save a shared ...