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