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.

FIELDVALUE Formula in Excel: Insert Data of Companies and Countries (+Download)

FIELDVALUE formula in Excel

Excel has – in it’s newest version – a quite useful new formula type. It’s called “linked data” and offers the functionality to automatically insert data from the internet to your table. This can be done with the FIELDVALUE formula and works in a first test quite well. Unfortunately, the available data types and options… Continue reading FIELDVALUE Formula in Excel: Insert Data of Companies and Countries (+Download)

Sort: How to Sort Data in Excel

There are several ways to sort data: Using filters, Pivot Tables or the built in Sort function. The sort function has the advantage that it’s easy to use and can be modified in detail.