scottyboy218

If you click on a pivot, the pivot ribbon appears. Under analyze, go all the way to the left. You'll see the name of pivot table, and then a little options button underneath. Don't click the word options, but to the right of it is a little drop-down. Click that, uncheck "generate get pivot data"

Why is =GETPIVOTDATA the default in Excel when you want to link to a cell in a pivot? I feel like most people want to be able to reference a pivot table and then drag a formula down/across without it being stuck to a single specific cell in a pivot.

Whatever I see someone has a ton of =GETPIVOTDATA, when I show them how to turn it off they're incredibly thankful. I appreciate that Excel makes it easy to turn off permanently though!

How do you best handle people who start quoting scripture and using it as an excuse for hatred/hostility?

How do you explain all the horrific, egotistical, maniacal, selfish, childish, petulant things that God did in the Old testament?

Are you religious? Do you believe God made you this way for a reason?

(I'd normally never ask this question, but it's AMA!)