How to Prevent Users to Restore PivotTable Source Data

In a “normal” PivotTable (without changing any of the default settings), other Excel users can easily restore the source data. Also, when you copy and paste the PivotTable into a new Excel file without the data. But what, if you want to prevent other users to see all the data? Here is how to do… Continue reading How to Prevent Users to Restore PivotTable Source Data

GETPIVOTDATA: Disable GETPIVOTDATA permanently in Excel

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.

How to Count Number of Unique Records in Excel: 5 Methods!

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… Continue reading How to Count Number of Unique Records in Excel: 5 Methods!