Select Show horizontal scroll bar and Show vertical scroll bar, and then click OK. On the Advanced tab, scroll to the Display section. You can change this setting to show the scroll bars instead. Less Show scroll bars in Word and Excel for Windows To work around this issue, use either a column label or the column position value to identify the column to use in the field parameter.Excel for Microsoft 365 Word for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac Excel 2021 Word 2021 Excel 2021 for Mac Word 2021 for Mac Excel 2019 Word 2019 Excel 2019 for Mac Word 2019 for Mac Excel 2016 Word 2016 Excel 2016 for Mac Word 2016 for Mac Excel 2013 Word 2013 More. Do not use quotation marks around the number. For example, the parameter can use 1 for the first column, 2 for the second column, and so on. When you use the DCOUNT and the DSUM functions on a PivotTable, the field parameter can only use a number to represent the position of the column within the list. This problem occurs because the field parameter of the DCOUNT and DSUM functions cannot use a cell reference or a column label to retrieve data from the database table.

In this scenario, when the DCOUNT and DSUM functions are calculated, they return the following error:Īnd, if you use the column label 'Total' for the fieldparameter, the DCOUNT and DSUM functions also return the '#VALUE!' error. The function is written as follows: DCOUNT(C10:F20,F10,H2:H12) The DCOUNT function parameters are as follows: The criteria for the function are H2:H12. The targeted column is F10, and this column has the column label of 'Total.' The database table on which the PivotTable is based is in N1:Q10. And, you use the cell reference for the column in the PivotTable for the field parameter of the database function.įor example, consider the following scenario. You use the PivotTable's cell references for the database parameter of the database function.

You enter a formula by using either of the following database functions: You insert a new PivotTable into the worksheet that is based on the new table's data. You create a table that has two or more columns of data on a worksheet. SymptomsĬonsider the following scenario in Microsoft Excel: For more information about this change, read this blog post.

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise.

Excel 2016 menu bar not work