I love pivot tables too, but would draw the line at cuddling with one. Each to his (or her) own taste! Learning Excel Thingies When you’re in a class that’s teaching you how to use a computer it would help if the teacher knew how to work Excel… Or a mouse. Whoever is teaching this [...]

When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference. To turn this feature off, follow the instructions in this short video. For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables.   ________________