Professor Excel
Disable GETPIVOTDATA permanently in Excel.

GETPIVOTDATA: Disable GETPIVOTDATA permanently in Excel

Does this sound familiar to you? You want to refer to a cell within a PivotTable, let’s say cell C6. But instead of getting =B6, Excel does something like =GETPIVOTDATA(“Value”;$A$3;”Name”;”c”). This article shows you how to permanently disable GETPIVOTDATA in Excel.

[…]

Count Number of Unique Records in Excel

Count Number of Unique Records in Excel: 5 Methods (+Download)

A common task in Excel is to find out the number of different entries in a list. For example, you have a list of names and want to know, how many different people are listed as some people might be multiple times on the list. This article introduces 5 different methods of counting the number of unique records in a list, regarding two major differences.

  1. You simply want to know the number of unique records. There is no other condition to be considered.
  2. You want to know the number of different entries under one or more conditions.

[…]

See and Change the Data Source of a Pivot Table in Excel

You receive an Excel workbook with a Pivot Table and don’t know what data it is referring to? Or you have added a column or row to your data and want to adapt the Pivot Table?

How to Avoid Changing the Column Width With Each Pivot Table Update

In a previous Excel Tip we have learned how to create a simple Excel Pivot Table. Now we will go on from there and learn how to eliminate one of the major pains of Pivot Tables: It changes the size of the columns after each update of the values.

Pivot Tables – How to Create a Pivot Table in Excel

You have some data and want to gain a quick overview? Or conduct some easy evaluation? Maybe later on analyze the data in more detail? For all these purposes, a Pivot Table can be a good choice.