Excel for Macintosh 2016

  1. Cannot make changes to the SharePoint list. Discard changes and refresh the page before making further changes to this list. ...
  2. Cannot merge changes from |0.Only copies of the same workbook can be merged. The workbook must be shared before making copies. ...
  3. Cannot refresh a PivotTable report until the refresh operation for the external data range on which the report is based is ...
  4. Cannot resize a table down when total rows are showing, and a feature such as a PivotTable report, array formula, or merged ...
  5. Cannot save to that file format.There are references to other sheets in this Workbook. Copy this sheet to a different Workbook ...
  6. Cannot update slicers, PivotTables, or cube functions.Reasons for this can include: The connection to the data source failed ...
  7. Causes a warning message to appear whenever you open a file that contains macros or customized toolbars, menus, or shortcuts. ...
  8. Caution: You are attempting to save a shared workbook that is also protected with a password. Portions of the file, including ...
  9. Change tracking is protected, and cannot be turned off or erased.To unprotect, use the Unprotect Workbook command (Tools ...
  10. Changes have been made to values in the PivotTable. If the changes are not published to the data source they will be lost. ...
  11. Changes the default date format from 2-digit years to 4-digit years. For example, if you type the date 5/28/1999, Excel displays ...
  12. Changes the starting date from which Excel calculates all dates from January 1, 1900 (Windows date system), to January 2, ...
  13. Changes the way Excel formulas refer to cells. Instead of using letters for columns and numbers for rows (called A1 notation, ...
  14. Changes to the Background Query option also change the option for other PivotTables based on the same source data. From now ...
  15. Changes to the Background Query option also change the option for other PivotTables based on the same source data. From now ...
  16. Changes to the Optimize Memory option also change the option for other PivotTables based on the same source data. From now ...
  17. Changes to the Optimize Memory option also change the option for other PivotTables based on the same source data. From now ...
  18. Changes to the Refresh On Open option also change the option for other PivotTables based on the same source data. From now ...
  19. Changes to the Refresh On Open option also change the option for other PivotTables based on the same source data. From now ...
  20. Changes to the Save Password option also change the option for other PivotTables based on the same source data. From now ...
  21. Changes to the Save Password option also change the option for other PivotTables based on the same source data. From now ...
  22. Changes to this option also change the option for other PivotTables based on the same source data.You will also be unable ...
  23. Changes were made using PivotTable what-if analysis to one or more values which no longer exist in the data source. These ...
  24. Charts or PivotTables in this workbook reference data in a restricted workbook.You do not have permission to reference the ...
  25. Check your parentheses, arguments, and references to other sheets. If you're not writing a formula, type a single quotation ...
  26. Clearing the PivotTable report is not allowed because at least one field is restricted and therefore cannot be dragged off ...
  27. Click a line style and color, and then click a preset border pattern or individual border buttons. You can also apply borders ...
  28. Click the Add button in the Define Name dialog box to define a name without closing the dialog box. You can add any number ...
  29. Click the AutoSum button on the Standard toolbar to quickly sum a row or column of numbers with the Sum function. You can ...
  30. Clicking a cell, object, or chart item while holding down CONTROL displays a shortcut menu containing formatting commands. ...
  31. Clicking an object or a chart item while holding down CONTROL displays a shortcut menu containing the Clear or Clear Contents ...
  32. Clicking an object while holding down CONTROL displays a shortcut menu containing the Order menu and Bring To Front command. ...
  33. Clicking an object while holding down CONTROL displays a shortcut menu containing the Order menu and Send To Back command. ...
  34. Clicking grouped objects while holding down CONTROL displays a shortcut menu containing the Grouping menu and Ungroup command. ...
  35. Client components for SharePoint Foundation are not available or are not the correct version. You will not be able to edit ...
  36. Cloud ConnectedAccess your recent documents on any device through seamless integration with OneDrive, SharePoint, and more. ...
  37. Column sorting, filtering, and layout changes are not being retained for this external data range. To retain these changes, ...
  38. COMMAND+L aligns the selection to the left.To define a name for the selected cell(s), press CONTROL+L.Some shortcut keys ...
  39. COMMAND+R aligns the selection to the right.To fill right, press CONTROL+R.Some shortcut keys have changed in this version. ...
  40. Compatible with Excel version 4.0 for Macintosh. Some advanced features, such as list objects and PivotTable reports, are ...
  41. Completes text entries you start to type in a column of data. If the first few letters you type match existing entries in ...
  42. Conditional formatting cannot be preserved in PivotTables.If you apply this formatting, the next time you refresh the PivotTable ...
  43. connection,kpi_name,kpi_property,caption!Returns a key performance indicator (KPI) property and displays the KPI name in ...
  44. connection,member_expression,caption!Returns a member or tuple from the cube.!is the name of a connection to an OLAP cube!is ...
  45. connection,member_expression,property!Returns the value of a member property from the cube.!is the name of a connection to ...
  46. connection,member_expression1,.!Returns an aggregated value from the cube.!is the name of a connection to an OLAP cube!is ...
  47. connection,set_expression,caption,sort_order,sort_by!Defines a calculated set of members or tuples by sending a set expression ...
  48. connection,set_expression,rank,caption!Returns the nth, or ranked, member in a set.!is the name of a connection to an OLAP ...
  49. Connections to external data sources can be used to access confidential information, or to cause harm to your computer. If ...
  50. contains sound notes.If you save '|' in Microsoft Excel X format, the sound notes will be permanently lost. To keep the sound ...
  51. CONTROL+B clears the selected cell's contents.To apply bold formatting, press COMMAND+B.Some shortcut keys have changed in ...
  52. Convert '|' to a calculated column?This will propagate your formula in this column to the rest of the rows in the list, overwriting ...
  53. Copies a color palette to the active workbook from another currently open workbook. Click the name of the other workbook ...
  54. cost,date_purchased,first_period,salvage,period,rate,basis!Returns the prorated linear depreciation of an asset for each ...
  55. cost,salvage,life!Returns the straight-line depreciation of an asset for one period!is the initial cost of the asset!is the ...
  56. cost,salvage,life,per!Returns the sum-of-years' digits depreciation of an asset for a specified period!is the initial cost ...
  57. cost,salvage,life,period,factor!Returns the depreciation of an asset for a specified period using the double-declining balance ...
  58. cost,salvage,life,period,month!Returns the depreciation of an asset for a specified period using the fixed-declining balance ...
  59. cost,salvage,life,start_period,end_period,factor,no_switch!Returns the depreciation of an asset for any period you specify, ...
  60. could not be found.Check the spelling of the file name, and verify that the file location is correct.If you are trying to ...
  61. Could not create or save the file.Click OK, and make sure that space is available and that you have permission to save files ...
  62. Creates a custom list from existing items in a data range. Click in the Import List From Cells box, select the range on the ...
  63. Creating the list in the place chosen will overwrite other data. Do you want to replace the contents of the destination cells? ...
  64. criteria_range,criteria,.!Counts the number of cells specified by a given set of conditions or criteria!is the range of cells ...
  65. Crop your picture to remove any unwanted areas.Check out the dropdown for more options such as cropping to a specific shape ...
  66. Damage to the file was so extensive that repairs were not possible. Excel attempted to save your formulas and values, but ...
  67. Data could not be retrieved from the database.Check the database server or contact your database administrator. Make sure ...
  68. Data will be removed from an external data range with uncommitted changes. Uncommitted changes will be lost, do you want ...
  69. database,field,criteria!Adds the numbers in the field (column) of records in the database that match the conditions you specify!is ...
  70. database,field,criteria!Averages the values in a column in a list or database that match conditions you specify!is the range ...
  71. database,field,criteria!Calculates the standard deviation based on the entire population of selected database entries!is ...
  72. database,field,criteria!Calculates variance based on the entire population of selected database entries!is the range of cells ...
  73. database,field,criteria!Counts nonblank cells in the field (column) of records in the database that match the conditions ...
  74. database,field,criteria!Counts the cells containing numbers in the field (column) of records in the database that match the ...
  75. database,field,criteria!Estimates the standard deviation based on a sample from selected database entries!is the range of ...